[AccessD] Automated emails from Access requiring validation for each email

You can use an SMTP method which doesn't need Outlook.  I've used vbSendMail
for several years.

http://www.freevbcode.com/ShowCode.asp?ID=109

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Gould
Sent: Friday, September 25, 2009 2:09 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Automated emails from Access requiring validation for
each email

I have a module that sends emails to every student that meets certain
criteria. It cycles through the recordset and sends an email with an
attached report (RTF format) to the student. I am using DoCmd.SendObject and
everything works perfectly except that someone has to sit at the computer,
wait until the email is about to be sent and then click on "Allow".

 

Is there a way to safely automate the sending of the emails (we are using
Access 2007 and Outlook 2007) so they don't require a babysitter?

 

TIA

 

David Gould

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com