View Single Post
 
Old 04-26-2017, 02:07 PM
tech123 tech123 is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2017
Posts: 1
tech123 is on a distinguished road
Default How do I mail merge records into table columns with more than one merge field?

Hello, I want to mail merge over 1000 records. In excel, I have columns for principal names, principal emails, individualized links, districts, school names, sde contact, and status (complete/incomplete) and so on. In the mail merge, I want to create a table for all completed responses from principals. That table would their name, email, and link. In another table, I want to list principals who didn't have a response (incomplete). This table would have the name and school listed. These two tables will be sent to one sde contact. One email per SDE contact. Each SDE contact will get a list of principals who completed/or did not complete the survey. I know how to do a basic mail merge but don't know how to set this up.

The email would like something like this:
Dear SDE contact,

Good morning. Our office has been working to collect individualized messages for the 2017 report card for <District>.

We have not received responses from:
Name Email Individualized Link




We have received responses from:
1. Name, School
2. Name, School
3. Name, School
Reply With Quote