I have a normal mail merge set up (Word 2016 with datasource in Excel 2016) with 400+ records. I would like the resultingoutputted letters to be saved individually with partof the filename coming from the data source in PDF format. Currently, I’m renaming them individually once merged and doing File | Save As | PDF for each one –there has to be a better way!
The Excel data source has column headings: FirstName; Surname; FullName;Region; IncentiveAmount; FileName. The FileName column is the concatenationof the Region, FirstName and Surname (copy/paste special values to remove theformula). So each column is juststraight text in each column (no formulas).


I'd like the letters to merge into individual files withthe resulting filename being "Incentive letter - Filename" referringto the FileName column in the data source so it shows the person's region and name in the filename, saved in PDF format (I have Acrobat Standard, so no batch processing unfortunately). How can I do this using VBA with aone click function to run the macro over and over so it results in 400+individual letters with unique filenames and as PDF please? I'm aware of gmayor's work but I'm not after all the dialogue boxes.

If saving as PDF as well is too ambitious,I’d be eternally grateful for just getting the individualfilenames in Word.

Thanks so much!