View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Need to send Outlook E-mail from Excel VBA without warnings.

Hi Prz59,

See Ron De Briun's suggestions at:

http://www.rondebruin.nl/mail/prevent.htm


---
Regards,
Norman



"Prz59" wrote in message
...
I'm trying to automate the sending of a spreadsheet from via Outlook. I
have
the code in place to build the spreadsheet and setup the Outlook
Application
object and the MailItem object. It sends the message but gives me a
warning
that requires a user interaction. Is there a way to bypass this warning?