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
|