Automatic E-mail

  • Thread starter Thread starter James X. Bond
  • Start date Start date
J

James X. Bond

Hi!

I would like my application to send e-mail
messages "automatically" when the form loads or opens
without user's interaction or not clicking any button.

Example: All Employees Due To Replace Their ID Cards

Please send me a good example.
Thank you!

Regards,

Jojo
 
Hi James,

Basically you just need to create a query that has the parameters to pull
the list of employees that are "due". Then using a DAO recordset, loop
through the results to create and send the email. Here are some articles
that should help you - note that the first is written for Access97 but the
majority of the article is still valid for later versions of Access.

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Outlook for the Summer (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm
 
Thank you so much...
But I need to try it by myself!
-----Original Message-----
Hi James,

Basically you just need to create a query that has the parameters to pull
the list of employees that are "due". Then using a DAO recordset, loop
through the results to create and send the email. Here are some articles
that should help you - note that the first is written for Access97 but the
majority of the article is still valid for later versions of Access.

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Outlook for the Summer (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?
Click to expand...
url=/library/en-us/dnofftalk/html/office071299.asp

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Hi!

I would like my application to send e-mail
messages "automatically" when the form loads or opens
without user's interaction or not clicking any button.

Example: All Employees Due To Replace Their ID Cards

Please send me a good example.
Thank you!

Regards,

Jojo
Click to expand...

.
Click to expand...
 
Back
Top