Avoiding Outlook Warnings When Emailing From Access

[Craig]

Does anyone know how to block the warning message when using VBA to send out
an email with a file attached? The code that I have works fine except for the
warning message from Outlook.

Thanks!

 

[Daniel Pineault]

There are various work arounds.

1. Install a program that clicks the yes button for you (for security
reasons I do not recommend this approach, but it does work)
http://www.snapfiles.com/get/clickyes.html

2. Use cdo to send your e-mail
http://www.mvps.org/access/modules/mdl0019.htm
http://support.microsoft.com/kb/286431/
http://support.microsoft.com/kb/286430/

3. Install redemption
http://www.dimastr.com/redemption/

also worth reading
http://accessblog.net/2006/12/auto-click-yes-to-outlook-security.html as well
as http://www.outlookcode.com/article.aspx?id=52

Tony' pages covers numerous e-mail technics and is worth your while to check
out http://www.granite.ab.ca/access/email.htm

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Craig]

Daniel,

I tried downloading Microsoft CDO 1.21 onto my machine but the download
center in MS says that I can since I don't have Office 2007 on my machine. I
won't be getting Office 2007 on my machine anyways. Would MS CDO for Windows
2000 work for this?

Thanks,
Craig

 

[Douglas J. Steele]

Read the links Daniel suggested (specifically
http://support.microsoft.com/kb/286430/ and
http://support.microsoft.com/kb/286431/ )They specifically mention CDO for
Windows 2000