Trun off Access warning message when sending email from Access

[Pablo]

Hi, there,
I have a table which has a field (Email) populated with Email address.
I am trying to send email using MS Outlook to those addresses.
Everything works fine except that a warning message will pop up for
every Email address stored in the table. I found that the following
code caused the warning message:
Recipients.Add(rst.Fields("Email"))

Basically, the warning message has the following statment:
"A program is trying to access e-mail addresses you have stored in
Outlook. Do you want to allow this? If this is unexpected, it may be a
virus and you should choose 'No'."

There is one thing I want to make clear:
Most of the address in the table are not sotred in Outlook.

Question:
1. How to turn the warning message off? It is annoying that it pops up
with every single Email address.
2. Even though I am using Recipients.Add(...). The email address is
not stored into the Outlook, why it says "A program is trying to
access e-mail addresses you have stored in Outlook"?.

Thanks in advance.
Pablo

[Tony Toews]

pa*****@hispavista.com (Pablo) wrote:

Basically, the warning message has the following statment:
"A program is trying to access e-mail addresses you have stored in
Outlook. Do you want to allow this? If this is unexpected, it may be a
virus and you should choose 'No'."

There are a couple of solutions in the Outlook section of the Access Email FAQ at my
website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm