Disabling Security Messages (Macros)

[Guest]

Not sure if this belongs here or in outlook questions but please help if you
can.

I am trying to use a macro to automatically send emails (with attachments)
to my customers via outlook. The problems is that i am sending 1 email to
each customer and i keep getting the warning message " A program is trying to
send an email on your behalf - do you want to allow it". If i click yes then
the email is sent but then it appears again for the next email that is to be
sent.

Can i disable this to allow all email to be sent without manually clicking
yes for each individual email?

Help on this would be very much appreciated.

Thanks

Andy

 

[Bob Phillips]

See http://www.rondebruin.nl/mail/prevent.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

See http://www.rondebruin.nl/mail/prevent.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)

Thanks For That - Just what i needed.

 

[Norman Jones]

Hi Andy,

Visi Ron de Bruin's site and check:

http://www.rondebruin.nl/mail/prevent.htm

 

[Norman Jones]

Hi Bob,

Sorry, I did not see your earlier response.

 

[Bob Phillips]

Hi Norman,

No problems. Let he who is without sin cast the first stone . So I won't
be saying anything <ebg>

Bob

 

[Guest]

I am using the following simple coding to do the same thing.

Sub xEmailing()
Workbooks.Open Filename:= _
"C:\Work Book Name.xls"

Windows("Work Book Name).xls").Activate
ActiveWorkbook.SendMail Recipients:="Email Adress"
ActiveWorkbook.Close
end sub

Can you give me some idea of the coding to be used to automatically answer
the Question "YES" when the the following apears

" A program is trying--
Thank you in advance for your Help