Mass Emailing

[forrestgump]

I recently set up a form which takes the results of a query of which I can then send out emails automactically to all the selected people.

However when the emails have been sent I want the unique ID and the todays date to record in another table so I have a record of when the email was sent.

Is this possible?

(Apologies If I have not been very concise)

[nico5038]

Just create a new query based on the "email query" and set the querytype to "Append" query.
Access will ask for the target table and select the fields you want to put into this "trace table".
To get the trace table defined, you could run this query first as "MakeTable" query and when filled for the first time, change the type to "Append query".

Getting the idea ?

Nic;o)

[forrestgump]

Nico,

Cheers for this. I didn't do it quite as you have said but it set me thinking.

Bascially I ran an append query to get the ID into the table and then I ran a update query to input the date =now() after if the the email sent field "Is null".

Cheers

Forrest Gump