There are many solutions to run Word Mail Merges from Excel. However, I would like to do it from a WORD vba macro instead as follows: 1. Run a mail merge in Word (therefore, have the vba in Word) 2. Create a separate pdf for each form letter generated 3. Use the "Client Name" from the excel table for each Word file

So far I have the following code which only makes a pdf for the first page in the merge. I gave it the name "C:\File.pdf". However, I'd like to somehow view the mail merge/excel table as an object and go through all 602 records in a loop (there are 602 records in the excel table it is based upon) and each time it goes through the loop, it takes the "Client Name" for that record and uses that to name the pdf for that iteration. Any help is greatly appreciated.

Sub PrintToPdf()


Set myMerge = ActiveDocument.MailMerge
If myMerge.State = wdMainAndSourceAndHeader Or _
myMerge.State = wdMainAndDataSource Then
With myMerge.DataSource
.FirstRecord = 1
.LastRecord = 5
End With
End If
With myMerge
'Next line will create pdf
'Challenge is to DIM some "merge" as ? of Item as ? and run through all in excel source
'and save PDF based on Client Name
ActiveDocument.ExportAsFixedFormat OutputFileName:="C:\File.pdf", ExportFormat:=wdExportFormatPD
F
End With
End Sub