Excel Macro to create PDF files using Word template 

Exactly what I was looking for. Can't tell you how happy I am to have found this video!

Very very good, used it already. Thank u very much.

Very helpful. Simple and solid solution. Thank you very much!

great video. This is close to what I am looking. I have a list in excel like this and Word mail merge. Do you know how to create a print button to print what row I select? or enter a row number to print?

This video is very helpful

Thank you sir, this is very helpful! I have just one doubt- is it possibile to save pdf(s) by selecting a folder using the Application.FileDialog(msoFileDialogFolderPicker)? I'm trying with no success

Can you please help how to make the for loop dynamic

Hi thanks for the nice video..I need to attach pdf copies to the word doc template and then use the mail merge to send out mass emails I m able to create the emails using mailmerge and list but unable to add PDFs can you plz help..

Hi I have a image in word and want to add different name on that image. So I add text box. But when I run the macro all pdf show same name. Pls help

Thanks for the video - I'm getting a Run-Time Error when I hit 'Set wd = New Word.Application' - any idea why this could be?

sir if the name column has first name and surname and i want pdf to be saved with only first name and unique id only, then what should i do.

Hello sir...I am getting extra space in pdf when middle name is blank. Is there any solution sir plz help

Love the video! thank you! I seem to get stuck at wd.Selection.Find - giving this error: Object variable or with block variable not set. Please help!!!

You have webscraping for google chrome using Excel VBA? I tried using downloading Selenium but keep getting an error, I believe it may have been selenium download, google driver issues since I’ve read there’s issue with that? I’ve read Selenium has compatibility with Chrome old drivers? Even someone else in Github wrote a Selenium VBA code, and tried using that one, yet, didn’t work. dont know how to fix the issue. I’ve even completely uninstalled Chrome and installed Chrome again to begin from scratch, yet, kept getting error. If you can show the options using Selenium and how to download Selenium? And or if there are alternatives? Thx!

Hi Kamal, what if in my Word doc, there are more than one mail merge field, then how do I set the macro to include these fields to replace in every subsequent pdf?

May I know why there is a compile error "Next without For"?

hi can you please guide to save with header and footer of the word, in the current above code header is not getting saved

Thank you very much. I wrote the code but I think there's a lot of error. I wish I could've sent ss

can u help me. (Office 2012) So i already follow ur step completely. no error but it wont create the PDF. can u help me? Thank you Sub createPDFs() Dim wd As Word.Application Dim doc As Word.Document Set wd = New Word.Application wd.Visible = True For i = 2 To 7 Set doc = wd.Documents.Open("D:\Folder Sampah\Surat CB\template.docx") With wd.Selection.Find .Text = "" .Replacement.Text = Cells(i, 1).Value .Execute Replace:=wdReplaceAll End With doc.ExportAsFixedFormat OutputFileName:=ActiveWorkbook.Path & "/" & Cells(i, 2).Value & "_" & Cells(i, 1).Value & ".pdf", _ ExportFormat:=wdExportFormatPDF Application.DisplayAlerts = False doc.Close SaveChanges:=False Application.DsplayAlerts = True Next wd.Quit End Sub

Sir, I need this coding file

Hi.. I jus copied ur code.. pdf is getting created.. however none of the fields are merged.. what am I missing here.. can you help me.. thanks in advance.

Hi, word to PDF? Help me please

Hi I pretty much copied your code exactly and got a compile error. can you please help?