Mail Merge: Using One Excel File with Multiple Sheets

[Townshend]

Good day! I've followed the thread on combining multiple values into a single letter using mail merge here which I seem to follow: https://www.msofficeforums.com/mail-...html#post23345



Where I am getting stuck is utilizing an Excel file with two spreadsheets as sources of information.

The goal is to do a mail merge with one letter per ID, that references Name, Address, City, State, and ZipCode found on the Summary sheet along with information form the Detail sheet in the letter. Is this possible and if so, how? Also open to 3rd party tools that may assist.

Thanks!