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

Dan, will that work in Access.  The site says it is for VB6.

max


On 25/09/2009, Dan Waters <dwaters at usinternet.com> wrote:
> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>