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!

You can do that kind of thing without a mailmerge, using DATABASE fields. For a demonstration, see: https://www.msofficeforums.com/mail-...html#post67110

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks macropod, DATABASE it's a really interesting feature!

I'm also giving a look at another tutorial regarding "Catalogue Mailmerge" with the use of KEY.

Wonderful forum, great tutorials!

P.S. Please don't close the thread until I'm sure I understood the mechanics, thanks.

How do I copy the code inside the fields, in order to paste it here to get some advice?
I can see the code (ALT+F9) but if I copy, I get only the output, not the code.

You'd need a macro to extract the field code for pasting as text. See, for example: http://www.gmayor.com/export_field.htm#FieldToText

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I used mail merge with SEQUENCE and KEY, as in your tutorial "Catalogue Mailmerge".
It worked like a charme, your tutorial is very good and useful.

I've found a way to write some text in the first page only, non repeated for every group, in this way:

{QUOTE{IF{MERGESEQ}= 1 "{SET Key ""} FIRST_PAGE_TEXT"}" ... }

Thanks for everything, my problem was solved!