How to send Outlook 2003 e-mail message based on training registra

[Guest]

I am working on updates to a training registration system. Once a day, client
wants to send out confirmation e-mail messages (Outlook 2003) to each
employee that was registered for a class. Message would include details of
the training course. Additionally, they also want the immediate supervisor
(which is defined in database) to receive a copy of the Outlook message.
Likely that we will flag the sent messages so that we can pick up all unsent
messages in case the process was not completed for the previous day. If it is
simpler, we can also generate the e-mail as each registration is completed.

Any resources or examples that I can follow to create a quick solution?

Thank you in advance,
Dawn

 

[Guest]

There are a couple of different ways of sending e-mail using access.

There are 2 main choices for emailing from access. Using the SendObject
method or automating outlook. The Sendobject method is the simplest but is
more limited. I believe this is probably your best bet based on the
description of your needs. Automating outlook, opens all the various
functionalities to the developer, but I do not get the feeling you are
looking to use any advanced features.

Here are a few resources

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx
http://www.microsoft.com/technet/archive/mail/ml302.mspx?mfr=true
http://www.granite.ab.ca/access/email.htm


You have 2 choices on how to proceed.

1- using an event from your entry form (such as click of a submit button)
add code to send out an e-mail.

2- Set-up a routine that loop through all the record in the db that have not
been processed yet (which means you're going to need to store a field
indicating if an entry was processed) and send out bulk emails.