Macro - save multiple pages with mail merge data to seperate PDF

Radiant · #1 06-28-2023, 07:42 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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