Microsoft Office Forums and if statement in word mailmerge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 08-24-2017, 04:08 PM
macropod's Avatar
macropod macropod is online now and if statement in word mailmerge Windows 7 64bit and if statement in word mailmerge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
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

Precisely - every customer's first page will be numbered 1.



Perhaps you could attach a cut-down version of your data source with enough records to demonstrate how the 'Continued' data are used (delete anything sensitive - e.g. names & addresses). From the mailmerge main document you attached previously, it's not apparent how any customer would get two or more pages.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #17  
Old 08-25-2017, 09:06 AM
sbye sbye is offline and if statement in word mailmerge Windows 10 and if statement in word mailmerge Office 2016
Novice
and if statement in word mailmerge
 
Join Date: Aug 2017
Posts: 9
sbye is on a distinguished road
Default

Hi Paul,
I have attached a sample document (all customers are fictitious and the transactions are dummy transactions), the following would happen if you sent it to the printer duplex:

First piece of paper would have Aaron on page 1 but on the back (page 2) would be Abington which we would not want as they are sent through the post to customers.

Second piece of paper would have Adams and Company on page 3 and on back (page 4) would be Allen Bros.

Third piece of paper would have Amazon on and on the back would also have Amazon which is fine as both sides are for same customer.

We need it to insert a blank page if the even numbered page is for a different customer to the previous page. The example above would ideally print as:

Page 1 Aaron, page 2 blank, page 3 Abington, page 4 blank, page 5 Adams and Company, page 6 blank, page 7 Allen Bros, page 8 blank, page 9-11 Amazon, page 12 blank.

Hope this helps.

Thanks, Stephen.
Reply With Quote
  #18  
Old 08-25-2017, 09:59 PM
macropod's Avatar
macropod macropod is online now and if statement in word mailmerge Windows 7 64bit and if statement in word mailmerge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
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

Once again, no attachments to your post. What I need is some sample source data, not just output documents.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
and if statement in word mailmerge Microsoft Word IF statement issues micro44 Word 4 10-23-2014 12:10 PM
Help with IF statement in word 2010 Mad Word 2 04-06-2013 06:31 AM
and if statement in word mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
and if statement in word mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
and if statement in word mailmerge Word Mailmerge wont print aovc Mail Merge 1 05-06-2011 05:29 AM


All times are GMT -7. The time now is 04:20 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft