Avoid warning message from outlook when open it from a form

[shiro]

Hi All,
I have a module to sent email from access with attachment
is a pdf Access report.
But when trying to display outlook new message window,
outlook send a message:

"A program is trying to access e-mail addresses you have
stored in Outlook.Do you want to allow this?
If this unexpected,it may be a virus and you should choose
"NO"

I choose yes and click it,but this message will appear as
many as outlook contacts listed in my form listbox.( olTo ).

How to make this message dissapear?

Thank's

 

[Rick Brandt]

Hi All,
I have a module to sent email from access with attachment
is a pdf Access report.
But when trying to display outlook new message window,
outlook send a message:

"A program is trying to access e-mail addresses you have
stored in Outlook.Do you want to allow this?
If this unexpected,it may be a virus and you should choose
"NO"

I choose yes and click it,but this message will appear as
many as outlook contacts listed in my form listbox.( olTo ).

How to make this message dissapear?

Don't use Outlook for your Access Emails. That is a Windows/Outlook message,
not an Access message. I think they finally came up with a better solution in
Office 2007, but for other versions you pretty much need to use a different
messaging library like CDO or Redemption.

CDO has the advantage that it is already installed on all Windows 2000 and newer
PCs. Redemption is a separate product you would have to acquire and install on
each user's PC. There is also a free utility that will automatically respond
"Yes" to the security prompt.

 

[abajacks]

Don't useOutlookfor yourAccessEmails.  That is a Windows/Outlookmessage,
not anAccessmessage.  I think they finally came up with a better solution in
Office 2007, but for other versions you pretty much need to use a different
messaging library like CDO or Redemption.

CDO has the advantage that it is already installed on all Windows 2000 andnewer
PCs.  Redemption is a separate product you would have to acquire and install on
each user's PC.  There is also a free utility that will automatically respond
"Yes" to the security prompt.

--
Rick Brandt, MicrosoftAccessMVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com- Hide quoted text -

- Show quoted text -

There is a program called ClickYes that will take care of this issue
for you.
If you go to the link below you can download it and it is free.
http://www.contextmagic.com/express-clickyes/