Merge 3 documents (Excel 97)

Topic

New Reply

I want to do a mail merge to Word but I have information on 3 separate Excel spreadsheets. Is there a way to do that? Thanks for any help.

Reply | Quote

Replies

I don’t use Word and MailMerge:
BUT
if this can NOT be done directly (maybe someone knows a direct way), you could create a single excel file which is LINKED to the other 3 files and then mail merge using the “combined” file. Changes made to the original 3 should be reflected in the combined file and thus in WORD.

Steve

Reply | Quote