View Single Post
 
Old 04-05-2016, 05:21 AM
mds mds is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2016
Posts: 4
mds is on a distinguished road
Default Mail merge into separate list

Hi all.

I have an Excel spreadsheet with two columns:
NAME JOB
Mark Baker
John Baker
Roger Medic
Brandon Cop
Alan Medic
Ben Cop
Edmund Baker

And so on (I'm simplifying my case).

I'd like to automate a mail merge document with the following result:

FIRST PAGE
Title

SECOND PAGE
List of all bakers

PAGE BREAK
List of all cops

PAGE BREAK
List of all medics

That's it.
I know the sintax
{ IF {MERGEFIELD JOB} = "Baker" "{MERGEFIELD NAME}" ""}
{NEXT}
but I don't know how to separate the lists, or how to put a title page.

Thanks in advance!
Reply With Quote