By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Mass Emailing

P: 34
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)
Oct 10 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 11 '07 #2

P: 34
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
Oct 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.