Microsoft Office Forums Duplex Merge Issue

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2016, 01:13 AM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default Duplex Merge Issue

Dear Sir,



I have Postcard template 4 per page. I have set up mail merge like label merge but one of my template (Template1) generating less records. It is generating pages 403 instead of 504 while second template (Template_New) is generating first page twice. Can you please point out my error and suggest improvements?

Kind Regards
Shehbaz H.
Attached Files
File Type: xlsx Mailing_List_New.xlsx (73.7 KB, 0 views)
File Type: docx Template1.docx (27.9 KB, 1 views)
File Type: docx Template_New.docx (29.9 KB, 1 views)
Reply With Quote
  #2  
Old 02-26-2016, 02:11 AM
macropod's Avatar
macropod macropod is offline Duplex Merge Issue Windows 7 64bit Duplex Merge Issue 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

You really should pay more attention to what you're doing. Your Template1 file has four «NextRecord» fields on the first page, which means four records get skipped every time that page is called. Open the document, press Alt-F9 and you'll immediately be able to see three of them...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-26-2016, 03:48 AM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default Duplex Merge Issue

Thank You Sir for guidance. I have removed all three next record indicators from page 1 but the result is same as there are still some records missing from the output file. Kindly check this revised template.

Regards
Attached Files
File Type: docx Template1.docx (27.7 KB, 2 views)
Reply With Quote
  #4  
Old 02-26-2016, 04:42 AM
macropod's Avatar
macropod macropod is offline Duplex Merge Issue Windows 7 64bit Duplex Merge Issue 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

There is still one more «NextRecord» field on the first page - with some other hidden content in the 3rd row.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 02-26-2016, 04:51 AM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default

Sir, I have tried to locate the next record by deleting one by each line of blocks of data but not fine any next record. You are right; it will be there but I am unable to fine. I shall be highly greatful to you if you could please remove these and sent back to me my template.

Kind Regards
Reply With Quote
  #6  
Old 02-26-2016, 05:00 AM
macropod's Avatar
macropod macropod is offline Duplex Merge Issue Windows 7 64bit Duplex Merge Issue 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

I have already told you where to find it - something you could easily have done for yourself. I am not going to do your work for you! You only got into this situation because of sloppy document construction.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 02-26-2016, 05:07 AM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default

Ok can you please tell me Next Records are attached with which line of words?
Reply With Quote
  #8  
Old 02-26-2016, 05:09 AM
macropod's Avatar
macropod macropod is offline Duplex Merge Issue Windows 7 64bit Duplex Merge Issue 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

I already did that.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 02-26-2016, 05:52 AM
gmayor's Avatar
gmayor gmayor is offline Duplex Merge Issue Windows 10 Duplex Merge Issue Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,802
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

As you seem to be struggling with Paul's instructions, which will certainly do the job, see http://www.gmayor.com/mail_merge_postcards.htm and
http://www.gmayor.com/duplex_name_label_merge.htm which the most popular widely used postcard formats. The two add-ins employ different approaches to the same task.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #10  
Old 02-26-2016, 06:27 AM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default

Sir GM,

Hi

Thank you so much for offering this Add-in. I am also using your add-in of split mail merge. Sir Paul is also my friend; I always remain busy to follow his instructions

Thank you once again you and Sir Paul also.

Kind Regards

Shehbaz h.
Reply With Quote
  #11  
Old 03-12-2016, 01:24 PM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default Duplex Merge Issue

Dear Sir Paul,

Hi

I have figured out the previous template. I am nowt facing every fifth record missing from my output file. Template and mailing list files are attached for review. Kindly guide me in this regard.

Kind Regards

Shehbaz H.
Attached Files
File Type: docx Test.docx (38.1 KB, 1 views)
File Type: xlsx List.xlsx (13.0 KB, 1 views)
Reply With Quote
  #12  
Old 03-12-2016, 07:27 PM
macropod's Avatar
macropod macropod is offline Duplex Merge Issue Windows 7 64bit Duplex Merge Issue 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

That's hardly surprising, since you have a «Next Record» field after every «Zip» field. You should not have it after the last one.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #13  
Old 03-12-2016, 09:40 PM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default Duplex Merge Issue

Thank you so much sir. The second page is now working but first page where property address are being pulled from excel displayed same on each four parts of first page. Please check and guide me sir.

Kind Regards
Shehbaz H.
Attached Files
File Type: docx Test.docx (38.0 KB, 1 views)
File Type: docx Output_Duplix Merge.docx (114.8 KB, 0 views)
Reply With Quote
  #14  
Old 03-12-2016, 10:30 PM
macropod's Avatar
macropod macropod is offline Duplex Merge Issue Windows 7 64bit Duplex Merge Issue 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

That is a necessary consequence of your document's structure - unless you put «Next Record» fields of the first page, it will always show the same record for all fields. Concersely, if you do put «Next Record» fields of the first page, it will skip four records per duplex set.

The attached re-working of your document overcomes those issues.
Attached Files
File Type: docx Test.docx (44.0 KB, 2 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #15  
Old 03-13-2016, 01:27 AM
fairchance fairchance is offline Duplex Merge Issue Windows 8 Duplex Merge Issue Office 2010 64bit
Advanced Beginner
Duplex Merge Issue
 
Join Date: Jun 2015
Posts: 55
fairchance can only hope to improve
Default Duplex Merge Issue

Sir,

Can you guide me how you set this field http://prntscr.com/aemant
so that I may be able to set it up in future by my own?

Kind Regards
Shehbaz H.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplex printing of documents from multiple Office progs mickprops Office 0 08-14-2015 06:04 PM
Duplex Merge Issue Mixed Duplex Printing jaygreg Word 2 01-29-2014 09:54 AM
Printing calendar pages with duplex cma6 Outlook 0 12-06-2012 07:29 AM
Duplex Merge Issue Duplex printing fireman0174 Word 1 09-26-2011 01:44 AM
Duplex Printing a merge doc AshlandMark Word 0 02-10-2009 12:29 PM


All times are GMT -7. The time now is 07:17 PM.


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