#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
||||
|
||||
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] |
#6
|
|||
|
|||
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! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2010 - directory mail merge - two separate group of data in one document | htsu | Mail Merge | 2 | 03-07-2016 03:10 PM |
Mail merge result in separate world files instead of one file containing all the data | xdhbsh | Mail Merge | 3 | 12-24-2015 12:23 AM |
Split each page of mail merge into separate pdf | Declan | Mail Merge | 1 | 05-28-2014 02:02 AM |
Creating separate file for each mail merge | doshshirl | Mail Merge | 3 | 02-15-2014 08:49 PM |
Mail Merge Recipients List | TanMan | Mail Merge | 1 | 10-13-2011 06:36 PM |