Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2011, 08:28 AM
imogul imogul is offline Multiple Mail Merge? Windows XP Multiple Mail Merge? Office 2003
Novice
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.

Thanks
Reply With Quote
  #2  
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
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,761
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
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
[MS MVP - Word]
Reply With Quote
Reply

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 03:15 AM.


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.
MSOfficeForums.com is not affiliated with Microsoft