| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
| Macro for multiple charts | Excel Worksheet Functions | |||
Linear Mode
