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!
|