Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-26-2018, 12:00 PM
jbulldog jbulldog is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 2
jbulldog is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-26-2018, 05:22 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
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

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:
http://www.msofficeforums.com/mail-m...ps-tricks.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-05-2018, 09:40 AM
jbulldog jbulldog is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 2
jbulldog is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 02-05-2018, 12:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
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

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
[MS MVP - Word]
Reply With Quote
Reply

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 1 01-10-2018 10:22 PM
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


All times are GMT -7. The time now is 09:27 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft