Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-24-2011, 08:28 AM
imogul imogul is offline Multiple Mail Merge? Windows XP Multiple Mail Merge? Office 2003
Multiple Mail Merge?
Join Date: Jun 2011
Posts: 2
imogul is on a distinguished road
Default Multiple Mail Merge?

I need to make a form letter but the info I need is not in a convenient list. I was given 50 spreadsheets and word docs. The word docs contain the name and address, the spreadsheets contain dollar figures. Is there anyway to merge this all together? Some kind of mail merge macro maybe? Or should I try to import all this stuff into a separate document first to create a source doc? I'm kind of lost here. Any advice you guys could give me would be appreciated.

Reply With Quote
Old 06-24-2011, 07:20 PM
macropod's Avatar
macropod macropod is offline Multiple Mail Merge? Windows 7 64bit Multiple Mail Merge? Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,766
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of

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.
Paul Edstein
[MS MVP - Word]
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Mail Merge? Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Multiple Mail Merge? Specified mail merge (I think) hurstafus Mail Merge 1 06-16-2011 06:21 PM
Multiple Mail Merge? Concatenate/merge contents of multiple cells PSYloco Excel 2 05-14-2011 03:46 PM
Mail Merge nonworduser Mail Merge 0 08-24-2010 02:28 PM
Multiple Mail Merge? How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

All times are GMT -7. The time now is 05:40 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft