Excel 2007 : Pulling Data from Excel Workbook to Word table

[VBailey]

I need to pull info from a workbook and put it into a Word doc table. I'm not sure how to do a macro for it, but I've been trying a formula and can't figure out how to get it to work.

=If A#=([File.xls]sheet1!A#),((B#=([File.xls]sheet1!D#),(C#=([File.xls]sheet1!F#),(D#=([File.xls]sheet1!E#)),"ERROR")

Would this work? If not, how would I enter it as a macro?

Thanks,
Vanessa

[abousetta]

Hi Vanessa and welcome to the forum.

If I understand you correctly, you are better off using Mail Merge in Word and identifying the workbook/worksheet with the data as your list. There is a mial merge wizard that will walk you through the step until you master them.

abousetta