Word Mail Merge from access vba dates

[danhur]

THIS CAN'T BE HARD!
But it is for me.

What I want. I have a mail merge doc that works perfectly. But the date of the letter after it has been saved changes when reopened.

An Access mdb has data for membership. when a merged letter is sent out, it is saved for later review.

I have tried both the word fields, "date" and "createdate"! Each has their own errors.

When I use the date field it always updates to todays date. So if the letter was originally sent yesterday when we reopen the document its now with todays date.

If I use createdate the date is always the date that the document was originally created. I even tried merging to a template .dot file hoping the create date would be updated thru the new document when you use wdsendtonewDocument destination.

Any hints help or direction would be greatly appreciated.
Google searches address everything but what I am looking for.
Access 2000 and word xp are the programs I am using.

Dan

 

[meboz]

I have a similar system where you want the date on the letter to stay the same, that is, the date it was sent. Therefore, this date should be stored in a field in the database, not on the merge doc.

For each letter i send, when the merge is complete, i run an update query which updates the field 'lettersent' to todays date, which then corresponds to the date the letter was printed.

If you are keeping an electronic version of the letter then dont include a date field from word, only use the date field from the record source in your db