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" <ynissel@discussions.microsoft.com> wrote in message news:ACC6326D-4CD3-4019-BCC0-53E5D6E2E573@microsoft.com...
> 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" <ynissel@discussions.microsoft.com> wrote in message news:ACC6326D-4CD3-4019-BCC0-53E5D6E2E573@microsoft.com...
> > 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" <ynissel@discussions.microsoft.com> wrote in message news:BFF14601-9246-4030-AC5E-0C7AB0142973@microsoft.com...
> 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" <ynissel@discussions.microsoft.com> wrote in message news:ACC6326D-4CD3-4019-BCC0-53E5D6E2E573@microsoft.com...
>> > 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" <ynissel@discussions.microsoft.com> wrote in message news:BFF14601-9246-4030-AC5E-0C7AB0142973@microsoft.com...
> > 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" <ynissel@discussions.microsoft.com> wrote in message news:ACC6326D-4CD3-4019-BCC0-53E5D6E2E573@microsoft.com...
> >> > 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" <ynissel@discussions.microsoft.com> wrote in message news:DF4FAA12-FB60-4096-B903-7681031EBB2E@microsoft.com...
>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" <ynissel@discussions.microsoft.com> wrote in message news:BFF14601-9246-4030-AC5E-0C7AB0142973@microsoft.com...
>> > 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" <ynissel@discussions.microsoft.com> wrote in message news:ACC6326D-4CD3-4019-BCC0-53E5D6E2E573@microsoft.com...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>