Update field automatically following a mail merge

[Mikey]

I will use my database to mailshot to a number of
contacts. I want the "date of last contact" field for
each of the contacts who received the mail shot to
automatically reflect the date the mailshot was sent. The
mailshot is a word document. Is this possible? If so, how
do I programme this?

 

[PC Datasheet]

After the mailshot is complete, pop up a message asking if the mailshot was
successful. When the user answers Yes, use an update query to update the
mailshotdate field to Date().