Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2015, 04:40 AM
dlaslett dlaslett is offline Editing recipient list in mail merge from word 2007 not working Windows 7 64bit Editing recipient list in mail merge from word 2007 not working Office 2007
Novice
Editing recipient list in mail merge from word 2007 not working
 
Join Date: Mar 2015
Location: Manchester, UK
Posts: 4
dlaslett is on a distinguished road
Editing recipient list in mail merge from word 2007 not working
Default Editing recipient list in mail merge from word 2007 not working

Hi folks,



A bit of a weird one here that I can't find an answer to anywhere.

We have several documents that we use to perform mail merges.

They are all working with the exception of one.

Essentially, the recipient list / edit recipients functionality is not working. If we just with to merge and print one document (which is often the case), we would DESELCT ALL at the top of the edit recipients dialogue, select the record we want, and hey presto. However, word is ignoring what we select and printing all 10,000 records in the db.... going back into EDIT RECIPIENTS shows all records "ticked" again (the other documents don't do this - they remember what was ticked last and show the same records).

screenshots are attached

1) opening dialogue :

2) EDIT RECIPIENTS > DESELECT ALL > PICK RECORD

3) if we print out at this point - EVERYTHING prints.

going back into "EDIT RECIPIENT LIST" at this point shows that everything is once more selected.... in other documents it would "remember" what we selected...


It is interesting to note at this point that both the database name in the bottom left corner, and the "find duplicates" options are greyed out....
not sure if this has any bearing. The system was working up until yesterday. There have been no changes to the MDB, and I have looked for escape characters in the data etc.... very odd!



If anyone can shed any light on this, it would be much appreciated! It has been years since I have done anything with mail merges... (I did not set this up originally but it has been working perfectly for some years)

finally here is a screenshot from the "sister" document, which is working perfectly - db name not greyed out, and it remembers whatever we pick....

Both documents use different queries within the same database.....

Database name : P.A.M.Guarantees.mdb

Thanks all - word version is 2007

Dave
Attached Images
File Type: jpg mailmerge_1.jpg (35.6 KB, 12 views)
File Type: jpg mailmerge_2.jpg (116.9 KB, 12 views)
File Type: jpg mailmerge_3.jpg (118.7 KB, 12 views)
File Type: jpg mailmerge_4.jpg (123.0 KB, 12 views)
Reply With Quote
  #2  
Old 03-10-2015, 05:36 AM
gmayor's Avatar
gmayor gmayor is offline Editing recipient list in mail merge from word 2007 not working Windows 7 64bit Editing recipient list in mail merge from word 2007 not working Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,096
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 of
Default

Close Word. Press CTRL+SHIFT+Esc to ensure there are no running WinWord.Exe processes still running. If there are close them from the Task Manager. (Better still reboot the PC).

See http://www.gmayor.com/what_to_do_when_word_crashes.htm and ensure that you check the folder with the merge document for orphaned lock files.

Restart Word. Open the errant document. Set the document type to Normal Word document from Start Mail Merge on the Mailings Tab

Click Select Recipients and re-attach your data source.

You can if you wish, suppress the SQL prompt with a macro - see http://www.gmayor.com/word_vba_examples.htm - 'Toggle the SQL security entry in the registry through vba'

Has that fixed it?
__________________
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 03-10-2015, 06:03 AM
dlaslett dlaslett is offline Editing recipient list in mail merge from word 2007 not working Windows 7 64bit Editing recipient list in mail merge from word 2007 not working Office 2007
Novice
Editing recipient list in mail merge from word 2007 not working
 
Join Date: Mar 2015
Location: Manchester, UK
Posts: 4
dlaslett is on a distinguished road
Editing recipient list in mail merge from word 2007 not working
Default

Hi Graham, I shall do the above and report back shortly! Thank you for the quick response.

Dave
Reply With Quote
  #4  
Old 03-10-2015, 06:23 AM
dlaslett dlaslett is offline Editing recipient list in mail merge from word 2007 not working Windows 7 64bit Editing recipient list in mail merge from word 2007 not working Office 2007
Novice
Editing recipient list in mail merge from word 2007 not working
 
Join Date: Mar 2015
Location: Manchester, UK
Posts: 4
dlaslett is on a distinguished road
Editing recipient list in mail merge from word 2007 not working
Default

Hi Graham,

Done the above, but no change, unfortunately (VERY helpful website by the way). Could not see any lock files.

I tried following your instructions too using a completely new, blank word doc and I get the same issue - defaulting to ALL SELECTED in the list when clicking EDIT RECIPIENTS... very odd... comparing these word docs with the one that works, I see no difference apart from the VIEW in the access db.. i.e. they both use the same MDB, but different tables within... at operating systems level both have the same file attributes etc.

"Broken doc" uses QryAllDPCCertificates and "working doc" uses QryAllWallTiesCertificate... both last modified in 2010....

Best,

Dave
Reply With Quote
  #5  
Old 03-16-2015, 02:02 AM
dlaslett dlaslett is offline Editing recipient list in mail merge from word 2007 not working Windows 7 64bit Editing recipient list in mail merge from word 2007 not working Office 2007
Novice
Editing recipient list in mail merge from word 2007 not working
 
Join Date: Mar 2015
Location: Manchester, UK
Posts: 4
dlaslett is on a distinguished road
Editing recipient list in mail merge from word 2007 not working
Default

Hi Folks,

I am updating this in cvase it everyone helps as I have now got a solution.

As it turns out - the issue was size. There is an upper limit of 10,000 for mail merging in this manner. I've made a backup copy and deleted all records older than 2 years and now everything is working as it should.

Hope this is of some help to someone.

Dave
Reply With Quote
Reply

Tags
access 2007, mail merge problem, word 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Word 2007 Mail Merge suddenley not working unless I press Shift + F9? Elmiee Mail Merge 1 01-15-2014 12:37 AM
Editing recipient list in mail merge from word 2007 not working Recipient counter in Mail Merge Wizard displays only one digit in Word Liuneddu Word 1 08-13-2013 03:57 AM
Mail merge with a hyperlink for multiple recipient with different url's? prkk.06 Mail Merge 6 05-01-2013 06:42 AM
Editing recipient list in mail merge from word 2007 not working Edit mail merge recipient list Freddies_grandad Mail Merge 7 12-10-2012 11:05 PM
Excel 2007 to Word 2007 Labels mail merge not working rec Mail Merge 0 07-31-2010 10:45 AM

Other Forums: Access Forums

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