e-mail from Excel - Outlook warning msg box problem

  • Thread starter Thread starter patterson_m
  • Start date Start date
P

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
 
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.
 
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)




Home said:
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.
Click to expand...
 
Back
Top