Folks,
I have below macro to do mail merge in Excel, it does create new workbook for each record and save as separate workbooks, and file names as current date and time. What I need is the macro to create the new workbook or sheets and save as PDF format and the file name should be Mail Merge "Field 2 + Field 1 + Field 5". My sample files (attached) will explain better.
Thanks for your expertize and time.Please Login or Register to view this content.
Bookmarks