#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Thanks a lot! May I know if I can save the individual files as a Word file instead of PDF
|
#4
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Word Mail Merge File Save | mickeyw3340 | Mail Merge | 2 | 12-18-2012 11:30 AM |
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 |