Outlook, how to use VBA to send email to groups of contacts?

Question

How to use VBA to send email to groups of contacts?
I tried send email to contacts group but it didn't work.The email was sent, but nobody received it.

ovMailItem := ovOutlook.CreateItem(0);
ovMailItem.To := 'my contacts group or contacts group Email Address';
ovMailItem.Subject := 'test email';
ovMailItem.Send;

Answer 1

Hi @桐 梧 ,

Welcome!

Outlook VBA develop issue, so I add the "office-vba-dev" tag here to better help solve your issue.

I tried some search and found some existed VBA scripts which might could help, for your reference:
Sending Email to a List of Recipients Using Excel and Outlook
How to Send a Same Email to Each Member in an Outlook Contact Group Separately via VBA
(Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

Hope this can be helpful.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.