Mailmerge populates a done field?

[James123]

When a mail merge is run from access to word to create for example mailing
Letters. How do I get this to happen.

A field access gets populated automatically with the date the mail merge
Was last run.

So when a mailmerge is run from access to send out some letters a field gets
Populated with the date that letters have been sent with additional info if
needed?

I am totally lost on this, please help as much as you can.

Thanks guys.

James

 

[Joan Wild]

Not sure what this has to do with security, but I assume you have a query
that is used to do the mail merge.

Once it's complete, you would run an update query (based on your merge
query), that updates your LetterSent field with Date() (or Now() if you
also want the time it was done).

 

[James123]

Sorry must have posted in the wrong group,

Not sure what this has to do with security, but I assume you have a query
that is used to do the mail merge.

Once it's complete, you would run an update query (based on your merge
query), that updates your LetterSent field with Date() (or Now() if you
also want the time it was done).