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

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

--

HTH

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


"Andy@HycoMan" wrote in message
...
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" wrote:

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

--

HTH

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


"Andy@HycoMan" wrote in message
...
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

Thanks For That - Just what i needed.

Hi Andy,

Visi Ron de Bruin's site and check:

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

---
Regards,
Norman



"Andy@HycoMan" wrote in message
...
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

Hi Bob,

Sorry, I did not see your earlier response.

---
Regards,
Norman



"Bob Phillips" wrote in message
...
See http://www.rondebruin.nl/mail/prevent.htm

--

HTH

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


"Andy@HycoMan" wrote in message
...
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

Hi Norman,

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

Bob


"Norman Jones" wrote in message
...
Hi Bob,

Sorry, I did not see your earlier response.

---
Regards,
Norman



"Bob Phillips" wrote in message
...
See http://www.rondebruin.nl/mail/prevent.htm

--

HTH

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


"Andy@HycoMan" wrote in message
...
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

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".
--
Thank you in advance for your Help


"Andy@HycoMan" wrote:



"Bob Phillips" wrote:

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

--

HTH

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


"Andy@HycoMan" wrote in message
...
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

Thanks For That - Just what i needed.