Mailmerge update field once complete.

[dickohead]

Hi all,

I am trying to pull some data from an Access database based on whether a field value is 1 or 0 (yes or no, ticked or unticked). I have built the query and the correct data is selected. I then built a word document to generate a mail merge from this.
Pretty simple stuff so far.

What I want to do is update the database with a value of 1 on the field I originally selected on, so that if the same mail merge is run again, the same people will not receive the letter.

Make sense?

Select all records where somefield = 0
once the mail merge is comeplete
update all records where somefield = 0 with somefield = 1.

How can I get word to update the database with a new field value? I have set the letter to have Read/Write access to the database.

 

[neileg]

When I have used this type of functionality, I have used a user input to confirm whether the document has printed or not and prevented the user exiting the form until the answer is given. Too many things can go wrong to prevent a successful print to make this an automatic process, in my opinion.

 

[GaryPanic]

well you have a qry for the mail merge - copy this and change it to a update qry ()add an extra field - say mmdate (mm= mail merge) then update the field to the date letter sent "01/06/08 "
then filter the orginal qry ont his field to is null