Microsoft Office Forums Skip Pages in a Mail Merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2016, 03:49 AM
Chris Morris Chris Morris is offline Skip Pages in a Mail Merge Windows 7 64bit Skip Pages in a Mail Merge Office 2007
Novice
Skip Pages in a Mail Merge
 
Join Date: Jun 2016
Posts: 2
Chris Morris is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 06-02-2016, 05:40 AM
macropod's Avatar
macropod macropod is offline Skip Pages in a Mail Merge Windows 7 64bit Skip Pages in a Mail Merge 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

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 06-02-2016, 05:46 AM
Chris Morris Chris Morris is offline Skip Pages in a Mail Merge Windows 7 64bit Skip Pages in a Mail Merge Office 2007
Novice
Skip Pages in a Mail Merge
 
Join Date: Jun 2016
Posts: 2
Chris Morris is on a distinguished road
Default

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

Thread Tools
Display Modes


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
Skip Pages in a Mail Merge Skipping pages in a mail merge NewGirl Mail Merge 6 12-16-2011 07:16 AM
Skip Pages in a Mail Merge Automatically split Mail Merge based on number of pages SaneMan Mail Merge 1 12-03-2011 01:11 AM
Skip Pages in a Mail Merge 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


All times are GMT -7. The time now is 04:44 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