#1
|
|||
|
|||
Skip Pages in a Mail Merge
My dataset includes three fields "Invite_NMA", "Invite_SALT", and "Invite_Annual" which can be either true or false. The main document includes four sections: a covering page, followed by up to three extra forms for a grant applicant to complete. If they have been invited to apply for an NMA grant, then those pages should appear. If they have been invited to apply for a SALT grant, then those pages should appear, and likewise for an Annual Grant. Is there a way to skip whole pages based on a field's value so the recipient only receives the pages relevant to their invitation? I've seen what seems to be an alternative solution, whereby the covering letter is the "main" document and includes IF...THEN...ELSE fields with pointers to the supplementary sections. |
#2
|
||||
|
||||
Yes - simply insert the conditional content into IF fields, one for each condition. For example:
{IF{MERGEFIELD Invite_NMA}<> "" "Invite_NMA Letter"} {IF{MERGEFIELD Invite_SALT}<> "" "Invite_SALT Letter"} {IF{MERGEFIELD Invite_Annual}<> "" "Invite_Annual Letter"} or: {IF«Invite_NMA»<> "" "Invite_NMA Letter"} {IF«Invite_SALT»<> "" "Invite_SALT Letter"} {IF«Invite_Annual»<> "" "Invite_Annual Letter"} including the page breaks within each field, though you'd put the fields themselves all end-to-end without line breaks. Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown. The spaces represented in the field construction are all required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you for that - I think it was the last point that I had either missed or forgotten. Getting Word itself to create the two functions (the IF and then INCLUDETEXT) independently and then copying the INCLUDETEXT wholesale into the IF worked well. Just got some finer points to work on (headers and footers and page breaks) and then I'm there.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Skipping pages in a mail merge | NewGirl | Mail Merge | 6 | 12-16-2011 07:16 AM |
Automatically split Mail Merge based on number of pages | SaneMan | Mail Merge | 1 | 12-03-2011 01:11 AM |
Inserting pages at the end of a mail merge | morten_lysgaard | Mail Merge | 3 | 07-25-2011 11:19 PM |
delete blank pages from mail merge document | blusea | Word | 0 | 12-17-2010 06:10 PM |