Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2023, 07:42 PM
Radiant Radiant is offline Macro - save multiple pages with mail merge data to seperate PDF Windows 10 Macro - save multiple pages with mail merge data to seperate PDF Office 2019
Novice
Macro - save multiple pages with mail merge data to seperate PDF
 
Join Date: Jun 2023
Posts: 1
Radiant is on a distinguished road
Default Macro - save multiple pages with mail merge data to seperate PDF

Hi!



Newbie here. I tried scanning the previous posts here and I can't find a related post with my concern.

So here's my situation. I have a 65 pages document with merged data from excel. The excel file contains the information of the 35 recipients such as the name, position, address etc.

Is there a way I can use codes to save the files separately in pdf? The output should be 35 files (as reflected in my excel master data) containing the 65 pages.

Thanks in advance!!
Rad
Reply With Quote
  #2  
Old 06-28-2023, 10:06 PM
gmayor's Avatar
gmayor gmayor is offline Macro - save multiple pages with mail merge data to seperate PDF Windows 10 Macro - save multiple pages with mail merge data to seperate PDF Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Without seeing your document, you may find Merge and Split useful. This will create separate PDFs from your document or re-merge to separate PDFs.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro - save multiple pages with mail merge data to seperate PDF Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file sureshbvs Word VBA 1 03-12-2021 05:42 AM
Mail Merge - Multiple Pages - Access jglassnerHI Mail Merge 1 08-29-2020 06:14 AM
Macro - save multiple pages with mail merge data to seperate PDF Mail merge with multiple rows of data ARoude Mail Merge 3 09-10-2018 02:32 PM
Mail Merge - Covering Letter with multiple additional pages not always the same amount lsirobinson Mail Merge 3 10-11-2015 11:33 PM
Using mail merge to make place cards. One record with data over two pages drew.last Mail Merge 2 03-05-2015 04:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


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