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

	mailmerge_1.jpg (35.6 KB, 14 views)
	mailmerge_2.jpg (116.9 KB, 14 views)
	mailmerge_3.jpg (118.7 KB, 14 views)
	mailmerge_4.jpg (123.0 KB, 14 views)