Email From Access

[Ruzz2k]

Hi, is it possible to set which email account from the exchange server is used when sending automated email from access.

Also is it possible to avoid the security warning from outlook without a paid add in or dll, as I have a multuser environment.

Thanks.

 

[mtn]

The code snippet at this post: http://www.access-programmers.co.uk/forums/showthread.php?p=1148424#post1148424 can answer your first question about the email account you need to send the email from.

As for sending email without the security warning, use SMTP and you're at peace. SMTP codes are every where on this forum but if you're not able to find one then let me know.