Sending emails from Excel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending An Email 4
Outlook Email Help: selecting Voting button option from excel VBA 12
Sending each spreadsheet via email to a different person 2
macro to automatically send an excel spreadsheet by email 1
Send e-mail based on condition 1
Send Email(s) by selecting users from user form 1
How can I get an email address from the GAL 3
How do I send an e-mail in Outlook triggered by results in Excel? 1

Top