I apologize ahead of time for being a novice on mail merge. I need some help in how to use the info on each record to populate different pages in the document. I source file is a spreadsheet with names, addresses, emails, an indicator on their attendance status and two different fields for comments.
I know how to get the fields into the document but am confused how to use the NEXT or NEXTIF or whatever to loop through the data.
One section is a list of people who entered as First time attendees
One section is a list of people who entered as Referred attendees
One section for anyone who entered one of two comment fields
What I working toward is:
(Page 1) EVENT: Rockstar
Location: Hillcrest
First Time Attendees
Mr. John Doe1
123 Cove Hollow Dr
Cedar Hill TX 75104-6222
email1@dummy.com
John Doe4
101112 Lake VIsta Drive
Dallas TX 75249-3005
email4@dummy.com
-------- new page --------------
(Page ?) EVENT: Rockstar
Location: Hillcrest
Referred Attendees
Mr. Jack Doe5
131415 Autumncrest Ct
Dallas TX 75249-3814
email5@dummy.com
Mr. Joe Doe6
161718 Shiloh Forrest Dr
Midlothian TX 76065-6877
email6@dummy.com
Mr. Jack Doe8
PO Box 222324
Grand Prairie TX 75053-0438
email8@dummy.com
----------new page-------------
(Page ?) EVENT: Rockstar
Location: Hillcrest
Comments from Cards
John Doe1 FAVORITE: The discussion
IMPROVE:
Jack Doe2 FAVORITE: Food - lol - the encouragement
IMPROVE: Need to get more men involved especially young Dads & husbands
Joe Doe3 FAVORITE: The reality of having men to be a part of who you can go to for reassurance
IMPROVE:
John Doe4 FAVORITE: Being together
IMPROVE:
Jack Doe5 FAVORITE: Gut check and group discussions
IMPROVE: Have these types of event at least four times a year.
Joe Doe6 FAVORITE: Topics hit the heart - thought provoking
IMPROVE:
John Doe7 FAVORITE: Good application on parenting after children turn 18. Love section gave good life application.
IMPROVE:
Jack Doe8 FAVORITE: The love 'gut check'
IMPROVE: