View Single Post
 
Old 03-10-2015, 04:40 AM
dlaslett dlaslett is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2015
Location: Manchester, UK
Posts: 4
dlaslett is on a distinguished road
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, 14 views)
File Type: jpg mailmerge_2.jpg (116.9 KB, 14 views)
File Type: jpg mailmerge_3.jpg (118.7 KB, 14 views)
File Type: jpg mailmerge_4.jpg (123.0 KB, 14 views)
Reply With Quote