#1
|
|||
|
|||
How to name a pdf output with Word 2016 mailmerge
Hi everyone. I have a Word 2016 doc set up to do a mailmerge from an excel 2016 spreadsheet and then export to separate pdfs for each record. It works perfectly. But I would like to be able to use the data from one, hopefully two of the execl columns to name the output pdfs respectively. Currently the pdfs documents are named with a generic name with sequential numbering.
For example: if two of the columns were titled Country and Name I would like each pdf record to be output with a name that reflects the name and country for its respective record. i.e. : United States John Smith Mexico Juan Pablo Brasil Noah Arujo Can it be done and if so how? Thanks in advance for any help with this. |
#2
|
||||
|
||||
Did you look in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum? There's a macro there for doing exactly that:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Yes I did thanks for the link. However nothing totally applied. There was one solution that was close but when adding the code and changes I did not see that the individual pdf outputs were named accordingly to the column record data selected.
The instructions were quite vague as well. Granted I have very limited VBA experience. Thanks again. |
#4
|
||||
|
||||
In that case, it's an implementation problem; the code under Send Mailmerge Output to Individual Files does precisely what you say you want to do.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Send Mailmerge Output to Individual Files - Help with VBA | plupton | Mail Merge | 2 | 12-24-2019 07:18 AM |
Send Mailmerge Output to Individual Files - troubleshooting help | mxk372 | Mail Merge | 1 | 07-06-2017 03:49 PM |
Mailmerge Directory - Incomplete Data Appearing in Merge Output | Gwinnett | Mail Merge | 5 | 03-05-2017 02:24 PM |
Word producing 2 PDFs on Output | bencox | Word | 0 | 01-06-2017 06:09 AM |
Input from excel, output to word | conradin | Word | 3 | 04-20-2011 07:48 PM |