Mass Emailing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • forrestgump
    New Member
    • Sep 2007
    • 34

    #1

    Mass Emailing

    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
    Recognized Expert Specialist
    • Nov 2006
    • 3080

    #2
    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)

    Comment

    • forrestgump
      New Member
      • Sep 2007
      • 34

      #3
      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

      Comment

      Working...