word mailmerge from access updates date wrong

[demi4u]

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

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

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

I have used 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.

Demi

 

[PHV]

Have you tried this ?
Selection.InsertDateTime DateTimeFormat:="dd/MM/yyyy", [highlight]InsertAsField:=False[/highlight]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[demi4u]

Hey PH, thank you, I was trying it from the Word side with a merge document, all the form fields are there.

Can this be done thru the word document itself or from...

From access vba module:
Your way would be to make a bookmark
then go to the bookmark and select the bookmark
and then use your code?

Sorry, Dan

 

[hhowiee]

I've found it as simple to add the current date NOW() to the query that feeds the mailmerge. In this way you just bring a constant value into the merge from the expression field.