e-mail from Excel - Outlook warning msg box problem

[patterson_m]

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

 

[Ron de Bruin]

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

 

[Home]

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.

 

[Ron de Bruin]

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.aspx?scid=kb;en-us;263074&Product=xlw2K


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

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.

 

[dermot]

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/InsaneExcel/Default.html
Last updated August 2003