Thread: [Solved] Multiple Mail Merge?
View Single Post
 
Old 06-24-2011, 07:20 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi imogul,

A Word mailmerge document can only work with a single data source, so that would require all the relevant Excel data to be consolidated into a single workbook. The alternatives are to:
• employ a DATABASE field that your mailmerge main document can direct the merge to each of the Excel workbooks using a field in a 'main' workbook; or
• do something with vba
but, without knowing the structure of the workbooks and whether they're suitably structured for this, I can't give any advice on how you would do that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote