Macro Emailing an XLS via Outlook
Is there any way to shut off the Outlook notice that says "a program is
trying to send email on your behalf - are you OK with this ?" Also - Is there anyway to automatocally update links without asking you when the file opens ? Thanks |
Hi
1) http://www.rondebruin.nl/copy3.htm#sheet 2) When you open a file with code or manual -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Is there any way to shut off the Outlook notice that says "a program is trying to send email on your behalf - are you OK with this ?" Also - Is there anyway to automatocally update links without asking you when the file opens ? Thanks |
Sorry - Im confused. I dont see hpw this will stop that Outlook message ?
Also I dont see where it shows how to automatically update the links ? Thanks, Yosef "Ron de Bruin" wrote: Hi 1) http://www.rondebruin.nl/copy3.htm#sheet 2) When you open a file with code or manual -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Is there any way to shut off the Outlook notice that says "a program is trying to send email on your behalf - are you OK with this ?" Also - Is there anyway to automatocally update links without asking you when the file opens ? Thanks |
OOPS
Sorry I paste the wrong link http://www.rondebruin.nl/mail/prevent.htm 2) When you open a file with code or manual This was a question -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Sorry - Im confused. I dont see hpw this will stop that Outlook message ? Also I dont see where it shows how to automatically update the links ? Thanks, Yosef "Ron de Bruin" wrote: Hi 1) http://www.rondebruin.nl/copy3.htm#sheet 2) When you open a file with code or manual -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Is there any way to shut off the Outlook notice that says "a program is trying to send email on your behalf - are you OK with this ?" Also - Is there anyway to automatocally update links without asking you when the file opens ? Thanks |
I like the click yes - but I couldnt find the code to just add it into the
macro - as my file is opened by many users. "Ron de Bruin" wrote: OOPS Sorry I paste the wrong link http://www.rondebruin.nl/mail/prevent.htm 2) When you open a file with code or manual This was a question -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Sorry - Im confused. I dont see hpw this will stop that Outlook message ? Also I dont see where it shows how to automatically update the links ? Thanks, Yosef "Ron de Bruin" wrote: Hi 1) http://www.rondebruin.nl/copy3.htm#sheet 2) When you open a file with code or manual -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Is there any way to shut off the Outlook notice that says "a program is trying to send email on your behalf - are you OK with this ?" Also - Is there anyway to automatocally update links without asking you when the file opens ? Thanks |
ClickYes is running in the backround and you can not do it with code
-- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... I like the click yes - but I couldnt find the code to just add it into the macro - as my file is opened by many users. "Ron de Bruin" wrote: OOPS Sorry I paste the wrong link http://www.rondebruin.nl/mail/prevent.htm 2) When you open a file with code or manual This was a question -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Sorry - Im confused. I dont see hpw this will stop that Outlook message ? Also I dont see where it shows how to automatically update the links ? Thanks, Yosef "Ron de Bruin" wrote: Hi 1) http://www.rondebruin.nl/copy3.htm#sheet 2) When you open a file with code or manual -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... Is there any way to shut off the Outlook notice that says "a program is trying to send email on your behalf - are you OK with this ?" Also - Is there anyway to automatocally update links without asking you when the file opens ? Thanks |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com