Microsoft Office Forums Multiple Mail Merge?

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,536
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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 alternative is to 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 02:01 PM.


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