Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2012, 04:12 AM
Freddies_grandad Freddies_grandad is offline Edit mail merge recipient list Windows Vista Edit mail merge recipient list Office 2007
Novice
Edit mail merge recipient list
 
Join Date: Dec 2012
Posts: 4
Freddies_grandad is on a distinguished road
Unhappy Edit mail merge recipient list


Doing a mail merge for address labels for Xmas cards. When I try and exclude an entry by taking out the tick in the mail merge recipients list I can lose 2 or more names in addition to the one I want to exclude. What am I doing wrong?
Reply With Quote
  #2  
Old 12-07-2012, 08:15 PM
macropod's Avatar
macropod macropod is offline Edit mail merge recipient list Windows 7 64bit Edit mail merge recipient list 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

Unless there are multiple persons sharing the same record, unchecking a record should exclude only that person from the list.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-08-2012, 06:58 AM
Freddies_grandad Freddies_grandad is offline Edit mail merge recipient list Windows Vista Edit mail merge recipient list Office 2007
Novice
Edit mail merge recipient list
 
Join Date: Dec 2012
Posts: 4
Freddies_grandad is on a distinguished road
Default Edit mail merge recipient list

Quote:
Originally Posted by macropod View Post
Unless there are multiple persons sharing the same record, unchecking a record should exclude only that person from the list.
Thanks for your reply.
I agree that this is what should happen but I still have the problem. For instance if I take out the tick for the third entry on my list then I also lose entries 1 and 2. I then have to highlight entry 1 and OK it to reinstate entries 1 and 2. To reinstate entry 3 I then replace the tick and OK. This reinstates entry 3 to the top left label but removes entry 1. I then highlight entry 1 on the recipient's list and OK it to return the main document to its original state.
If this is the way it should happen then OK but this is not the way it is described in the wizard or the help screens.
There are no other users accessing the list of recipients.
Reply With Quote
  #4  
Old 12-08-2012, 02:33 PM
macropod's Avatar
macropod macropod is offline Edit mail merge recipient list Windows 7 64bit Edit mail merge recipient list 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

That suugests a problem with Word. Try repairing your Office installation (via Word Options|Resources|Diagnose).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-09-2012, 01:35 PM
Freddies_grandad Freddies_grandad is offline Edit mail merge recipient list Windows Vista Edit mail merge recipient list Office 2007
Novice
Edit mail merge recipient list
 
Join Date: Dec 2012
Posts: 4
Freddies_grandad is on a distinguished road
Default

Paul
Thanks for your prompt response and for taking the time out. I have run through the diagnostics as you suggested but it did not identify any problems. I don't think I can waste any more of your time, or mine. Although the tick boxes are not working as they should I have now used the work around so often that it comes naturally. So I think I'll leave it at that.
Thanks again
Mike Simpson
(Freddies_grandad)
Reply With Quote
  #6  
Old 12-09-2012, 04:19 PM
macropod's Avatar
macropod macropod is offline Edit mail merge recipient list Windows 7 64bit Edit mail merge recipient list 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

About the only other thing I can suggest is starting the mailmerge over again from scratch. If your data source is a Word table, convert that to text, then back to a table again (just in case there's some corruption in the table that's causing the problem).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 12-10-2012, 10:06 AM
Freddies_grandad Freddies_grandad is offline Edit mail merge recipient list Windows Vista Edit mail merge recipient list Office 2007
Novice
Edit mail merge recipient list
 
Join Date: Dec 2012
Posts: 4
Freddies_grandad is on a distinguished road
Default

Paul
Thanks for trying but the data source is in excel. I may try using word and see how that works.
Cheers
Mike Simpson
(Freddies_grandad)
Reply With Quote
  #8  
Old 12-10-2012, 11:05 PM
macropod's Avatar
macropod macropod is offline Edit mail merge recipient list Windows 7 64bit Edit mail merge recipient list 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

Hi Mike,

Although changing to a Word table might work, that's not really addressing the cause of the problem. For whatever vreason, it seems Word is treating these records as being linked somehow.

Regarding your Excel workbook, does it contain any merged cells?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge with a hyperlink for multiple recipient with different url's? prkk.06 Mail Merge 6 05-01-2013 06:42 AM
Edit mail merge recipient list mail merge stops midway and then generates messages with no recipient or subject VivaceTS Mail Merge 1 08-09-2012 05:31 PM
Edit mail merge recipient list How to edit recipient list rsmedley Mail Merge 1 03-17-2012 01:35 AM
Edit mail merge recipient list Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM
Problem with Edit Recipient List TanMan Word 0 10-05-2011 12:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 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