[AccessD] Silently send email from Access?

Christopher,
You could use vbSendMail, I can't remember the site I got it from but if you type it into a search engine I'm sure you will come up with something.  Basically it's like a ocx control and it sends mail directly to the SMTP server bypassing the security warnings.
Hope this helps.
Paul Hartland





Message date : Jan 16 2004, 11:15 AM
>From : Christopher Hawkins 
To : accessd at databaseadvisors.com
Copy to : 
Subject : [AccessD] Silently send email from Access?
I have used the DoCmd.SendObject command to send email from within an
application before, but with recent versions of Outlook this has
become cumbersome due to the security in place by default. Now the
user is prompted that something is attempting to access their
mailbox, etc.

I have been asked to make an application silently send email to
certain people when certain events occur in their system. They
specifically said they want all eMail from the app to be silent; no
security warnings.

I don't have the foggiest clue how to do this without disabling their
exchange server's security entirely, which is out of the question.

Is it possible for my application to execute the SendObject command
in an administrative context? Or something? Has anyone done this?

-Christopher-


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime