Thread: [Solved] Mail Merge: Using One Excel File with Multiple Sheets
View Single Post
 
Old 01-10-2018, 02:40 PM
Townshend Townshend is offline Windows 10 Office 2016
Novice
  
Join Date: Jan 2018
Posts: 4
Townshend is on a distinguished road
Default Mail Merge: Using One Excel File with Multiple Sheets
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!
Attached Files
File Type: xlsx test.xlsx (11.5 KB, 221 views)