Sending emails from Excel
 

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?

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?