Using SendObject in Access to send an email

  • Thread starter RGFsZSBGeWU
  • Start date Views 2,605
Status
Not open for further replies.
R

RGFsZSBGeWU

I've got some code in Access an Access 2007 database that generates a series

of email messages to a bunch of customers.

Unfortunately, the security settings of Outlook popup a warning menu with

each email that is generated. As I recall, in Office 2003, when this

happened, the user was presented with an option to allow that functionality

for a period of time, so they did not have to repeatedly wait for the warning

message to finish processing and then click the Accept button. Is there a

way to do this in Access/Outlook 2007 as well?

--
HTH

Dale
 
A

Albert D. Kallal

I was under the impression that in 2007, this message is gone.

Try either ensuing that access is in a trusted location, or try setting

macro security to low....

I have access 2007, but only have outlook 2003....

Try either of the above ideas....I don't have the reference, but I do recall

reading somwhere that that nag prompt is gone in one of the above cases....

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

pleaseNOOSpamKallal@msn.com
 
M

Mark Andrews

You could always go with a third party smtp component and avoid all these

issues.

Mark

RPT Software

http://www.rptsoftware.com

"Dale Fye" <dale.fye@nospam.com> wrote in message

news:FBD67EAC-DB60-4FF4-80C5-9D5319DBD317@microsoft.com...
> I've got some code in Access an Access 2007 database that generates a
> series
> of email messages to a bunch of customers.

> Unfortunately, the security settings of Outlook popup a warning menu with
> each email that is generated. As I recall, in Office 2003, when this
> happened, the user was presented with an option to allow that
> functionality
> for a period of time, so they did not have to repeatedly wait for the
> warning
> message to finish processing and then click the Accept button. Is there a
> way to do this in Access/Outlook 2007 as well?

> --> HTH
> Dale
>
 
K

Ken Slovak - [MVP - Outlook]

Low security isn't a good idea. However, in Outlook 2007 if you have an up

to date anti-virus program running the prompt won't occur in out of process

uses of the Outlook object model. SendObject() is a Simple MAPI call, not

Outlook object model. The results might be better if Outlook object model

code were used instead of a Simple MAPI call.

"Albert D. Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message

news:%23V2gX7rwJHA.5836@TK2MSFTNGP06.phx.gbl...
> I was under the impression that in 2007, this message is gone.

> Try either ensuing that access is in a trusted location, or try setting
> macro security to low....

> I have access 2007, but only have outlook 2003....

> Try either of the above ideas....I don't have the reference, but I do
> recall reading somwhere that that nag prompt is gone in one of the above
> cases....

> > Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@msn.com

>
 
Status
Not open for further replies.
Top