Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2018, 12:00 PM
jbulldog jbulldog is offline How to name a pdf output with Word 2016 mailmerge Windows 10 How to name a pdf output with Word 2016 mailmerge Office 2016
Novice
How to name a pdf output with Word 2016 mailmerge
 
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 How to name a pdf output with Word 2016 mailmerge Windows 7 64bit How to name a pdf output with Word 2016 mailmerge 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

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]
Reply With Quote
  #3  
Old 02-05-2018, 09:40 AM
jbulldog jbulldog is offline How to name a pdf output with Word 2016 mailmerge Windows 10 How to name a pdf output with Word 2016 mailmerge Office 2016
Novice
How to name a pdf output with Word 2016 mailmerge
 
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 How to name a pdf output with Word 2016 mailmerge Windows 7 64bit How to name a pdf output with Word 2016 mailmerge 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

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to name a pdf output with Word 2016 mailmerge Send Mailmerge Output to Individual Files - Help with VBA plupton Mail Merge 2 12-24-2019 07:18 AM
How to name a pdf output with Word 2016 mailmerge Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
How to name a pdf output with Word 2016 mailmerge 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
How to name a pdf output with Word 2016 mailmerge Input from excel, output to word conradin Word 3 04-20-2011 07:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 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