Microsoft Office Forums Mail merge into separate list

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2016, 05:21 AM
mds mds is offline Mail merge into separate list Windows 7 64bit Mail merge into separate list Office 2013
Novice
Mail merge into separate list
 
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
  #2  
Old 04-05-2016, 06:19 AM
macropod's Avatar
macropod macropod is offline Mail merge into separate list Windows 7 64bit Mail merge into separate list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-05-2016, 07:14 AM
mds mds is offline Mail merge into separate list Windows 7 64bit Mail merge into separate list Office 2013
Novice
Mail merge into separate list
 
Join Date: Apr 2016
Posts: 4
mds is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 04-05-2016, 08:35 AM
mds mds is offline Mail merge into separate list Windows 7 64bit Mail merge into separate list Office 2013
Novice
Mail merge into separate list
 
Join Date: Apr 2016
Posts: 4
mds is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 04-05-2016, 03:35 PM
macropod's Avatar
macropod macropod is offline Mail merge into separate list Windows 7 64bit Mail merge into separate list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #6  
Old 04-06-2016, 02:17 AM
mds mds is offline Mail merge into separate list Windows 7 64bit Mail merge into separate list Office 2013
Novice
Mail merge into separate list
 
Join Date: Apr 2016
Posts: 4
mds is on a distinguished road
Default

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!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge into separate list 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 into separate list 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
Mail merge into separate list Split each page of mail merge into separate pdf Declan Mail Merge 1 05-28-2014 02:02 AM
Mail merge into separate list Creating separate file for each mail merge doshshirl Mail Merge 3 02-15-2014 08:49 PM
Mail merge into separate list Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM


All times are GMT -7. The time now is 03:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft