Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2015, 09:03 AM
pcstockman pcstockman is offline Still Having Problems with Source Data Being Repeated Windows 7 64bit Still Having Problems with Source Data Being Repeated Office 2013
Novice
Still Having Problems with Source Data Being Repeated
 
Join Date: May 2015
Posts: 6
pcstockman is on a distinguished road
Default Still Having Problems with Source Data Being Repeated

I followed gmayor's advice re: putting in "Next Record" on the 2nd and 3d labels on a template containing three labels total. As a result, I am getting some, but not all, of the behavior on the mail merge I am looking for.

Within any given page of labels (3 per page, one across) the "Next Record" command does produce the merge field value from the next record. However, the second page of labels now starts with the merge field value from second record in the source file and displays merge values for the 2nd, 3d and 4th records. The third page of labels starts with the 3d record and displays the the merge values for the 3d, 4th and 5th records, etc. This happens both with my own custom 3-down, 1-across labels as well as with a test run I did on a standard Avery label template (#5126).

The source file is a simple Excel worsheet containing a single column of values with the first row in this column being the name of the merge field variable.

Any idea what is happening here?
Reply With Quote
  #2  
Old 05-21-2015, 01:18 AM
gmayor's Avatar
gmayor gmayor is offline Still Having Problems with Source Data Being Repeated Windows 7 64bit Still Having Problems with Source Data Being Repeated Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You are previewing the merge. You must complete the merge to a new document in order for the subsequent pages to populate correctly.
__________________
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
  #3  
Old 05-21-2015, 07:35 AM
pcstockman pcstockman is offline Still Having Problems with Source Data Being Repeated Windows 7 64bit Still Having Problems with Source Data Being Repeated Office 2013
Novice
Still Having Problems with Source Data Being Repeated
 
Join Date: May 2015
Posts: 6
pcstockman is on a distinguished road
Default Thanks. Problem Solved.

Mr. Mayor:

Thanks very much for your post. There is, indeed, a difference between the preview and the completed merge. The merged document is fine.

Needless to say I am mystified as to why Microsoft would provide a preview capability that allows one to step through the entire merge page-by-page but does not show accurate merge results. Its not really a preview at all. Unbelievably bad software design. Malicious software design, really, given the hours I have wasted on this.

Thanks, gmayor.
Reply With Quote
  #4  
Old 05-25-2015, 01:00 AM
DougMVP DougMVP is offline Still Having Problems with Source Data Being Repeated Windows 7 32bit Still Having Problems with Source Data Being Repeated Office 2010 32bit
Advanced Beginner
 
Join Date: Nov 2013
Posts: 50
DougMVP will become famous soon enough
Default

While the preview may not be very useful for a Label type mail merge (or a Directory type), it can be of benefit for a Letter type merge and especially if the mail merge main document includes If...then...Else field construction(s).
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Source Records are Being Repeated on Each Page pcstockman Mail Merge 5 05-21-2015 01:20 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
Still Having Problems with Source Data Being Repeated Refresh of data from external source Jirik61 Excel Programming 3 07-13-2012 01:40 PM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
pivot table source data hannu Excel 0 07-03-2010 04:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft