I am trying to set up a macro so that people can e-mail me back a
completed spreadsheet.

There are various VBA solutions in the top tips section, but when I use
them I get a 'Microsoft Outlook' message box, warning that someone is
trying to e-mail on my behalf and asking if to proceed (Yes or No).

Is there anyway to overide this message box (which is from outlook not
excel) or click through it automatically?

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Check out this Mark
http://www.rondebruin.nl/sendmail.htm#Prevent

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"patterson_m" wrote in message ...
I am trying to set up a macro so that people can e-mail me back a
completed spreadsheet.

There are various VBA solutions in the top tips section, but when I use
them I get a 'Microsoft Outlook' message box, warning that someone is
trying to e-mail on my behalf and asking if to proceed (Yes or No).

Is there anyway to overide this message box (which is from outlook not
excel) or click through it automatically?

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

I have really the same problem..

asking by macros automatic file sending. Users have Win 2000?

Some reasons why we need it..

At first site it might look a bit weird but creating report for not so
advanced users who should send results regularly to database it's required.




"patterson_m" wrote in message
...
I am trying to set up a macro so that people can e-mail me back a
completed spreadsheet.

There are various VBA solutions in the top tips section, but when I use
them I get a 'Microsoft Outlook' message box, warning that someone is
trying to e-mail on my behalf and asking if to proceed (Yes or No).

Is there anyway to overide this message box (which is from outlook not
excel) or click through it automatically?

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

This security warning is introduced in Office 2000 sr2

OFF2000: Using 'Send To' to Send E-mail Prompts After You Apply Outlook E-Mail Security Update
http://support.microsoft.com/default...&Product=xlw2K


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Home" wrote in message ...
I have really the same problem..

asking by macros automatic file sending. Users have Win 2000?

Some reasons why we need it..

At first site it might look a bit weird but creating report for not so
advanced users who should send results regularly to database it's required.




"patterson_m" wrote in message
...
I am trying to set up a macro so that people can e-mail me back a
completed spreadsheet.

There are various VBA solutions in the top tips section, but when I use
them I get a 'Microsoft Outlook' message box, warning that someone is
trying to e-mail on my behalf and asking if to proceed (Yes or No).

Is there anyway to overide this message box (which is from outlook not
excel) or click through it automatically?

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

here's a solution that works with Outlook, see my site
below....

Dermot Balson
Free VBA code for user interfaces, internet connectivity,
encryption
http://www.webace.com.au/~balson/Ins...l/Default.html
Last updated August 2003



-----Original Message-----
I am trying to set up a macro so that people can e-mail
me back a
completed spreadsheet.

There are various VBA solutions in the top tips section,
but when I use
them I get a 'Microsoft Outlook' message box, warning
that someone is
trying to e-mail on my behalf and asking if to proceed
(Yes or No).

Is there anyway to overide this message box (which is
from outlook not
excel) or click through it automatically?

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.