Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2014, 10:08 PM
623bookends 623bookends is offline Mail merge--skipping records Windows 7 64bit Mail merge--skipping records Office 2007
Novice
Mail merge--skipping records
 
Join Date: Mar 2012
Posts: 2
623bookends is on a distinguished road
Default Mail merge--skipping records

Hi. I am using an Excel SS as the source for records to be used in a MSWord mail merge. The master letter is set up 2 to a page (2 up), each 5.5" x 8.5" (half page size). The merge works fine except that every third record is not picked up. Thus, records #1 and #2 are picked up but #3 is skipped. Records #4 and #5 are picked up and #6 is skipped. And so on. I don't understand why or how this can be overcome.



Any suggestions????

Thanks.

Bookends623
Reply With Quote
  #2  
Old 01-12-2014, 03:43 AM
macropod's Avatar
macropod macropod is offline Mail merge--skipping records Windows 7 32bit Mail merge--skipping records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It's not clear from your post what kind of merge you're doing, as either a Letter merge or a Label merge be used for this, but the info you've provided suggests you have a «NextRecord» field after the second 'letter'. Delete that and everything should be fine.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-12-2014, 06:02 AM
623bookends 623bookends is offline Mail merge--skipping records Windows 7 64bit Mail merge--skipping records Office 2007
Novice
Mail merge--skipping records
 
Join Date: Mar 2012
Posts: 2
623bookends is on a distinguished road
Default Mail merge--skipping records

Thank you. Yes I am using a letter merge. And yes there is a 'nextrecord' after the second letter. I removed it and that resolved the problem. Many, many thanks. I never would have thought of that as the source of the problem.

Bookends623
Reply With Quote
Reply

Tags
mail merge skips records

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge--skipping records Multiple mail merge records on the same page allenglishboy Mail Merge 3 07-18-2012 06:22 AM
Mail merge--skipping records Skipping pages in a mail merge NewGirl Mail Merge 6 12-16-2011 07:16 AM
Mail merge--skipping records Mail Merge - Many Records for Each Addressee awalker1970 Mail Merge 1 12-31-2010 11:52 AM
Mail merge--skipping records Mail Merge Skipping 2 Labels when Printing mbsfirst Mail Merge 3 12-27-2010 04:28 PM
Mail merge--skipping records Combine Records when Mail Merge from Access Tom Pickles Misc 2 08-24-2010 06:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:30 AM.


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