Macro Emailing an XLS via Outlook

[Guest]

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

 

[Ron de Bruin]

Hi

1) http://www.rondebruin.nl/copy3.htm#sheet

2) When you open a file with code or manual

 

[Guest]

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]

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

 

[Guest]

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]

ClickYes is running in the backround and you can not do it with code