Mail Merge b/w Word and Excel

[FlixMixIntern]

Hi,

I have an Excel file, which has data spread out over 3 seperate "sheets". What I want to do is set up a mail merge in Word that will allow me to pull certain data from each sheet. But, when I set up the mail merge, it will only pull data from Sheet 1. How can I set up the merge to pull data from all three?? Thanks.

Cameron...

 

[Blakeseven]

I would set up a 3ed sheet. Map the fields you want to mail merge in the new sheet. Now you can pull the fields from the new sheet.