Sending emails from Excel

  • Thread starter Thread starter David Robinson
  • Start date Start date
D

David Robinson

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?
 
Back
Top