Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2014, 09:30 AM
doshshirl doshshirl is offline Creating separate file for each mail merge Mac OS X Creating separate file for each mail merge Office for Mac 2011
Novice
Creating separate file for each mail merge
 
Join Date: Feb 2014
Posts: 3
doshshirl is on a distinguished road
Default Creating separate file for each mail merge

Hi,



I would like to know if I can have each mail merge saved in one Word file instead of copying and pasting each of them into a separate file. I have 1,000 mail merges of transactions so i need to have 1,000 Word files.
Reply With Quote
  #2  
Old 02-15-2014, 03:33 PM
macropod's Avatar
macropod macropod is offline Creating separate file for each mail merge Windows 7 32bit Creating separate file for each mail merge 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

You can do this with a macro. See: http://www.gmayor.com/individual_merge_letters.htm. The code there is for a PC, though, and would probably need modification to work on a Mac.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-15-2014, 06:05 PM
doshshirl doshshirl is offline Creating separate file for each mail merge Mac OS X Creating separate file for each mail merge Office for Mac 2011
Novice
Creating separate file for each mail merge
 
Join Date: Feb 2014
Posts: 3
doshshirl is on a distinguished road
Default

Thanks a lot! May I know if I can save the individual files as a Word file instead of PDF
Reply With Quote
  #4  
Old 02-15-2014, 08:49 PM
macropod's Avatar
macropod macropod is offline Creating separate file for each mail merge Windows 7 32bit Creating separate file for each mail merge 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

The link shows how you can save to a variety of formats, PDF being only one of them. See, for example, the 'Split the single merged document into separate letters' example. See also the discussion at: http://www.mrexcel.com/forum/general...ml#post3694494. With the specific post linked to, you can generate PDFs or docx files - or both at the same time - using the same basic code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating separate file for each mail merge Mail Merge in Word: creating a rule for blanks cgranada Mail Merge 6 02-27-2017 09:08 AM
Creating new documents from a mail merge template pnjcarter Mail Merge 1 02-03-2014 06:42 PM
Creating separate file for each mail merge Word Mail Merge File Save mickeyw3340 Mail Merge 2 12-18-2012 11:30 AM
Creating separate file for each mail merge how do i ad a specific pdf file to a mail merge? mseibel Mail Merge 1 08-28-2012 07:53 PM
Need help creating a data base for mail merge. acedking90 Mail Merge 0 07-27-2009 11:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.


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