View Single Post
 
Old 08-23-2016, 01:42 PM
hrhr3 hrhr3 is offline Windows XP Office 2007
Novice
 
Join Date: Aug 2016
Posts: 3
hrhr3 is on a distinguished road
Default Merging Multiple Rows in Mail Merge Letter

Hi,

I want to create a mail merge letter that merges similar records. For example, my data set is as follows:
Department Employee
Education Mitch Mays
Education Sam Fields
Education George John
Math Jessica Tom
Math Joy Frank
Science Thomas Phillip

I want to have a letter listing the employees under the Education Department and a letter for employees under the Math Department etc.

I have tried following the instructions of several threads but am not very savvy in this area. Any assistance would be most helpful.

The actual documents are attached.
Attached Files
File Type: xlsx Test Data.xlsx (9.9 KB, 32 views)
File Type: docx Test Letter.docx (12.7 KB, 28 views)
Reply With Quote