#1
|
|||
|
|||
Can I populate Merge data on different pages?
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: |
#2
|
|||
|
|||
I was experimenting with the DATABASE command I have seen in other posts but I keep getting an Error! Cannot open data source.
I even tried the full path name for the excel file because I couldn't get the FILENAME \p /../ to work for me. Here is what I wrote (goes along with the data source file I posted earlier) {DATABASE \d "C:\Users\Scott\Desktop\Mail Merge\event-feedback-sample.xlsx" \s " SELECT [first_name], [last_name] WHERE [FAVORITEPART] IS NOT NULL ORDER BY [last_name]" \l "15" \b "49 \h} |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) | wvlls | Word VBA | 1 | 03-22-2019 02:29 PM |
Using mail merge to make place cards. One record with data over two pages | drew.last | Mail Merge | 2 | 03-05-2015 04:37 PM |
Med Template-We need a sub header to populate subsequent pages after info is entered on first page. | studiogeek | Word | 10 | 09-15-2014 03:10 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Populate Data to another cell | Mrkieth | Excel | 2 | 04-29-2013 07:30 AM |