Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2011, 10:37 AM
eonelson eonelson is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2010 32bit
Novice
Merge Doc skips records
 
Join Date: Jan 2011
Posts: 6
eonelson is on a distinguished road
Default Merge Doc skips records

I have approximately 150 records in MS Excel that I am attempting to merge to labels in MS Word.



All fields agree. When I scroll through one record at a time, they all appear. However, when I run the merge records are skipped. One one merge it skipped every other record. On another it skipped some at what seemed a random pattern.

I have resaved each document to make sure they were all either MS 2010 or MS 2003 across both excel and word. I tried every reconfiguration I could think of and it still doesn't work. Unfortunately it ended up me not having material for some meeting attendees. . . .

Does anyone have any suggestions?

Thanks.

Eileen
Reply With Quote
  #2  
Old 01-28-2011, 01:18 PM
macropod's Avatar
macropod macropod is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2000
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

Hi Eileen,

What sort of merge (letter, label, catalog/directory)? If it's a letter or catalog/directory merge, you shouldn't have 'Next Record' fields.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-28-2011, 02:37 PM
eonelson eonelson is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2010 32bit
Novice
Merge Doc skips records
 
Join Date: Jan 2011
Posts: 6
eonelson is on a distinguished road
Default

Yes, one of them was a directory merge and that is one that skipped every other one. But if I didn't put a next record it seemed not to put anything in?

The other was a merge to labels, or name tags rather, and it skipped here and there all the way through. I haven't gone back and really looked at it, just realized when I was putting everything out that names had been skipped - that were in my excel sheet.

Thanks.
Reply With Quote
  #4  
Old 01-28-2011, 02:50 PM
macropod's Avatar
macropod macropod is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2000
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

Hi Eileen,

Check that there are no double quotes in any of the data fields in your source file.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-28-2011, 03:04 PM
eonelson eonelson is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2010 32bit
Novice
Merge Doc skips records
 
Join Date: Jan 2011
Posts: 6
eonelson is on a distinguished road
Default

No double quotes in any of the files.
Reply With Quote
  #6  
Old 01-28-2011, 03:06 PM
macropod's Avatar
macropod macropod is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2000
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

Hi Eileen,

Can you attach a copy of your problem mailmerge main document and a cut-down copy of your mailmerge data source to a post? If so, I'll take a look at them for you.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 01-28-2011, 03:30 PM
eonelson eonelson is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2010 32bit
Novice
Merge Doc skips records
 
Join Date: Jan 2011
Posts: 6
eonelson is on a distinguished road
Default

I am attaching a copy of the excel doc and the merge doc. I ran it just now again. The one I particularly remember was Jamie from Kleins did not get a welcome label. . .and then found that others didn't either -- and that is how I realized the merge didn't work correctly.
Attached Files
File Type: xlsx AttendeesforForum.xlsx (35.7 KB, 28 views)
File Type: docx FolderLabelsforforum.docx (118.9 KB, 37 views)
Reply With Quote
  #8  
Old 01-28-2011, 04:22 PM
macropod's Avatar
macropod macropod is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2000
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

Hi Eileen,

Delete the last 'Next Record' field and everything should be OK.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 01-30-2011, 12:02 PM
eonelson eonelson is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2010 32bit
Novice
Merge Doc skips records
 
Join Date: Jan 2011
Posts: 6
eonelson is on a distinguished road
Default Omitting next record on merge

If I omit the next record it gives me a whole page of labels for each record. I thought you had to have <next record> in order to move from one line to another in excel.

Can you explain, please?

Thanks.

Eileen
Reply With Quote
  #10  
Old 01-30-2011, 01:23 PM
macropod's Avatar
macropod macropod is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2000
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

Hi Eileen,

Is said only to :
Quote:
Delete the last 'Next Record' field
It sounds like you've deleted all of them.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 01-30-2011, 01:27 PM
eonelson eonelson is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2010 32bit
Novice
Merge Doc skips records
 
Join Date: Jan 2011
Posts: 6
eonelson is on a distinguished road
Default

OK - got it -- I skimmed right over "last". I figured it had to be something fairly simple. . . .

You said something about not using next record if I do a directory -- won't the same thing happen?

Thanks.
Reply With Quote
  #12  
Old 01-30-2011, 03:49 PM
macropod's Avatar
macropod macropod is offline Merge Doc skips records Windows 7 32bit Merge Doc skips records Office 2000
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

Hi Eileen,
Quote:
You said something about not using next record if I do a directory -- won't the same thing happen?
No, with a Directory/Catalogue merge, Word assumes you want all records and simply outputs them one after the other. If you insert a Next Record field, that'll cause Word to skip records.

If you're wanting to do something more than a simple Directory/Catalogue merge, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
merge, skipped records

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Doc skips records Mail Merge - Many Records for Each Addressee awalker1970 Mail Merge 1 12-31-2010 11:52 AM
Merge Doc skips records Combine Records when Mail Merge from Access Tom Pickles Misc 2 08-24-2010 06:00 PM
Cursor skips to previous lines KimM Office 1 01-09-2010 08:13 AM
Help with consolidating multiple records into one wbiggs2 Excel 0 11-30-2006 01:02 PM
Skips too many lines: stumptagen Word 0 03-24-2006 11:19 AM

Other Forums: Access Forums

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


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