Sending emails to multiple recipients using vbscript

vbscript outlook mapi
duper picture duper · Jul 3, 2012 · Viewed 30.6k times · Source

My vbscript sends email to automatically to a recipient, but does anyone know how to add more than one recipient to it?

...
Dim ToAddress
Dim FromAddress
Dim MessageSubject
Dim MyTime
Dim MessageBody
Dim MessageAttachment
Dim ol, ns, newMail
MyTime = Now

ToAddress = "[email protected]"
MessageSubject = "It works!."
MessageBody = "Good job on that script." 
MessageAttachment = some attachment
Set ol = WScript.CreateObject("Outlook.Application")
Set ns = ol.getNamespace("MAPI")
Set newMail = ol.CreateItem(olMailItem)
newMail.Subject = MessageSubject
newMail.Body = MessageBody & vbCrLf & MyTime
newMail.RecipIents.Add(ToAddress)
newMail.Attachments.Add(MessageAttachment)
newMail.Send

This is what I have right now. And it works fine. But, I'd like to have more than one recipients. Thanks in advance.

newMail.CC = "[email protected];[email protected];[email protected]"

This above line worked!

And it works the same way with .BCC, in case anyone wants to not to display the contacts' list.

Answer

Dmitry Streblechenko picture Dmitry Streblechenko · Jul 3, 2012

Call MailItem.Recipients.Add for each recipient or set the To/CC/BCC properties to a ";" separated list of addresses.

Related questions

Create a folder in Outlook: error 800A0401 - Expected End of Statement

I created a .vbs file to create a folder in Outlook. I copied most of the script out of MSDN and get "Expected End of Statement" error code 800A0401 Option Explicit Dim myNameSpace As Outlook.NameSpace Dim myFolder As Outlook.…

Read More
Regular Expression Rules in Outlook 2007?

Is it possible to create rules in Outlook 2007 based on a regex string? I'm trying to add a filter for messages containing a string such as: 4000-10, a four digit number followed by a dash and then a two digit …

Read More
How to avoid Outlook Security Alert when sending Outlook message from VBScript?

I have this situation: Code must be in VBScript (outside of my control) Unable to disable programmatic access restrictions in Outlook preferences (group policy, not admin, and Windows doesn't recognize the valid virus scanner which is installed) Can't use SMTP …

Read More