Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Merge seems to be repeating data Merge seems to be repeating data
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2014, 08:32 PM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default Merge seems to be repeating data
Hey guys,

Ive been reading up on how to fix this problem but I just cant seem to sort it out myself *derp*
I need to merge a list of multiple people which varies every week into this format. This is the current format Im using, but when I try and merge the datain it just adds the first person on the list over and over, I can never get the other people listed into the mail merge.

What am I doing wrong?

Hope someone can please help me out, would really appreciate some help.


Attached Files
File Type: xls data.xls (25.5 KB, 12 views)
File Type: doc Format.doc (45.5 KB, 13 views)
Reply With Quote
  #2  
Old 08-01-2014, 09:00 PM
macropod's Avatar
macropod macropod is offline Merge seems to be repeating data Windows 7 32bit Merge seems to be repeating data Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
After all except the last of your «AmountOwing» fields, you need to insert a «NextRecord» field - from the 'Rules' dropdown. The «NextRecord» field could go in the adjacent cell, for example.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-01-2014, 10:46 PM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default
That didnt work, I did try that.
Reply With Quote
  #4  
Old 08-01-2014, 10:47 PM
macropod's Avatar
macropod macropod is offline Merge seems to be repeating data Windows 7 32bit Merge seems to be repeating data Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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 does work. Are you Finishing the merge, or just doing a Preview? A preview won't show the finalised results.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 08-01-2014, 11:17 PM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default
I am finishing off the merge. Its not even including everyone on that list. Its just listing 1 person.
Reply With Quote
  #6  
Old 08-01-2014, 11:43 PM
macropod's Avatar
macropod macropod is offline Merge seems to be repeating data Windows 7 32bit Merge seems to be repeating data Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
Works for me just fine with your data & document - after I fixed all your mis-named mergefields...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 08-02-2014, 04:57 PM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default
what the fruit am I doing wrong? Its still got the 1 person showing up on the one page the next page has the next person.


I am at the point where I am prepared to pay you to fix it
Reply With Quote
  #8  
Old 08-02-2014, 05:05 PM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default
what is incorrect? And I can see the nextrecord field after the merge too.
Attached Files
File Type: doc Format2.doc (50.0 KB, 10 views)
Reply With Quote
  #9  
Old 08-02-2014, 09:33 PM
macropod's Avatar
macropod macropod is offline Merge seems to be repeating data Windows 7 32bit Merge seems to be repeating data Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
Quote:
Originally Posted by jerkfay View Post
what is incorrect?
Do you mean what, apart from the fact you've done nothing like what I said in post #2:
Quote:
After all except the last of your «AmountOwing» fields, you need to insert a «NextRecord» field - from the 'Rules' dropdown.
Not only haven't you done that, but you've also merely copied/typed «NextRecord» before the mergefields for every Name, Phone # and Amount owing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 08-03-2014, 02:48 AM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default
Im really sorry Paul. I do appreciate your help immensely im sorry to be annoying or frustrating. Im just not understanding which cell it should be in.
Reply With Quote
  #11  
Old 08-03-2014, 02:52 AM
jerkfay jerkfay is offline Merge seems to be repeating data Windows 8 Merge seems to be repeating data Office 2010 64bit
Novice
Merge seems to be repeating data 		 
Join Date: Aug 2014
Posts: 8
jerkfay is on a distinguished road
Default
I did it! I am so sorry for annoying you.

Thank you once again.
Reply With Quote
  #12  
Old 08-04-2014, 06:45 AM
macropod's Avatar
macropod macropod is offline Merge seems to be repeating data Windows 7 32bit Merge seems to be repeating data Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
Presumably your mailmerge main document will now look something like the attached.
Attached Files
File Type: doc mailmerge.doc (48.0 KB, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge seems to be repeating data Merge data from excel into word jonpackbosoxfan Excel 34 09-18-2013 08:38 AM
Merge seems to be repeating data Merge data files jmhultin Outlook 2 08-09-2013 02:01 PM
Merge seems to be repeating data Collation of mail merge data Nibbles Excel 2 04-16-2013 07:59 AM
Merge seems to be repeating data Mail Merge / DSN / Data Link / MySQL Bob Young Mail Merge 5 05-18-2012 03:44 PM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:11 PM.

Contact Us - Privacy Statement - Top

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