Disabling Security Messages (Macros)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy@HycoMan - 14 Oct 2005 10:35 GMT

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

Reply to this Message

Bob Phillips - 14 Oct 2005 11:45 GMT

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

Signature

HTH

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

> Not sure if this belongs here or in outlook questions but please help if you
> can.
[quoted text clipped - 14 lines]
>
> Andy

Reply to this Message

Andy@HycoMan - 14 Oct 2005 12:24 GMT

> See http://www.rondebruin.nl/mail/prevent.htm
>
[quoted text clipped - 20 lines]
> >
> > Andy

Thanks For That - Just what i needed.

Reply to this Message

Hans Dummer - 21 Jun 2006 12:50 GMT

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

> > to
> > > send an email on your behalf - do you want to allow it".

Signature

Thank you in advance for your Help

> > See http://www.rondebruin.nl/mail/prevent.htm
> >
[quoted text clipped - 22 lines]
>
> Thanks For That - Just what i needed.

Reply to this Message

Norman Jones - 14 Oct 2005 12:47 GMT

Hi Bob,

Sorry, I did not see your earlier response.

---
Regards,
Norman

> See http://www.rondebruin.nl/mail/prevent.htm
>
[quoted text clipped - 23 lines]
>>
>> Andy

Reply to this Message

Bob Phillips - 14 Oct 2005 13:27 GMT

Hi Norman,

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

Bob

> Hi Bob,
>
[quoted text clipped - 31 lines]
> >>
> >> Andy

Reply to this Message

Norman Jones - 14 Oct 2005 12:45 GMT

Hi Andy,

Visi Ron de Bruin's site and check:

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

---
Regards,
Norman

> Not sure if this belongs here or in outlook questions but please help if
> you
[quoted text clipped - 18 lines]
>
> Andy

Reply to this Message