Excel to Word Mail Merge VBA

I have an excel spreadsheet that collects information from other team members (2 records/rows each), I'm looking to implement a button that opens the word mail-merge document, populates the data (without the annoying SQL connection confirmation popup) and processes the mail-merge process up to the print selection screen or directly save to PDF. The fact that each member would download the 2 files (Excel and Word documents) on their own system's "My document" folder and the user name/path would be different on each, I've tried to create the path using the Environ userprofile command.

I can get it to the point where the application and file open and populate the data (code below), but I can't get it to complete the mail-merge. Any suggestions are much appreciated.

Please Login or Register  to view this content.