Macro to use mail merge with word and then save each printout as a pdf

[muhleebbin]

Can someone help with the coding to save a letter template in Word that will fill with each persons name (column a) via mail merge and then save each page as a unique file name under (column B)?

 

[Macropod]

See Send Mailmerge Output to Individual Files and Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html