Disabling Security Messages (Macros)
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 |
Disabling Security Messages (Macros)
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 |
Disabling Security Messages (Macros)
"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. |
Disabling Security Messages (Macros)
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 |
Disabling Security Messages (Macros)
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 |
Disabling Security Messages (Macros)
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 |
Disabling Security Messages (Macros)
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. |
All times are GMT +1. The time now is 02:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com