Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 AM.


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