Thread: Sending emails from Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Sending emails from Excel
Hi David

Read this
http://www.rondebruin.nl/sendmail.htm#Prevent


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



"David Robinson" wrote in message ...

I am programing my excel to send pre formatted emails to
people if certain conditions are met.

Is there an alternative to this:

Set MailRecipients = MailItem.Recipients.Add
("Broker1Email")

Eg MailItem.Recipients = " "

Can I have the program automatically say yes to Outlook's
dialogue box requesting that allow the program to access
the address book?




Reply With QuoteReply With Quote