Open the Mail Merge document and click the Mailings tab at the top of the window. Cell B3 is to contain name of your combined PDF. Once you have such a file, you can use the Acrobat JavaScript method Doc.importTextData () to import one record at a time (just like we did manually before). Open the Add-Ins tab and click on Convert All to finish the Mail Merge and create the Code 128 … It is very easy … When the code completes, Word is made visible with a new document open. Else, the code example that I am going to show you here will not produce the desired result.
We are actually creating a loop that uses a variable counter as the loop's 'time keeper.' Download the Excel Mail sending Macro from here or use the written code … The first method is to use the Macro Recorder. The first thing you have to do is to see the actual field code. Re: Mail Merge To Pdf To E-mail Attachment Yes, you've got it. I have an excel file in which I have a macro that creates a series of PDF files via the ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ command. This procedure process each mail via loop.
The idea of mail merge is simple & powerful.