Hi,

Does anyone has an example file of an excel file using Publisher and Excel. The idea of my proposed automation is when a button clicked in excel it will open the Publisher file, use the mail merge and get each line from excel without manual intervention. Do anyone has any simplest codes that can be shared with, I will be trying to decode it for my reference.

There is a certificate template in Publisher and names on a Spreadsheet. I cant do the mail merge perfectly so the idea is copying pasting data from excel to publisher. But mail merge will solve the problem and also automating the process with Excel VBA will be so much great.


I hope someone could help. Thanks a lot.

Regards,
Sarah