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?