Yes. In Excel VBA on Windows, you can create an Outlook email and add several addresses to its Recipients collection, or place multiple addresses separated by semicolons in the To field. The example below reads addresses from a worksheet, checks that Outlook can resolve them, and displays a draft for review instead of sending it immediately.
How VBA addresses multiple recipients
An Outlook email has a recipients collection: each address is a recipient with a type such as To, CC, or BCC. VBA can add each address separately, then ask Outlook to resolve the names against its address book or recognize them as email addresses. This approach makes it easier to validate the complete recipient list and assign different recipient types than entering one long string in the To property.
For a small, fixed list, a semicolon-separated value is also straightforward. For example, Outlook’s To field can contain alex@example.com; pat@example.com. This is convenient for a one-off message, but it offers less control when the addresses come from rows in a workbook, contain blanks, or need to be split between To and BCC.
In an Excel macro, the usual pattern is to create an Outlook mail item, add addresses, set the subject and body, and call .Display or .Send. These are different actions: Display opens a draft for a person to inspect, while Send submits it to Outlook’s outgoing mail process.
Requirements and Outlook version differences
The code here is for Excel for Microsoft 365 on Windows and automates classic Outlook for Windows through its COM interface. Classic Outlook must be installed and configured with an account. The example uses late binding, so it does not require selecting an Outlook reference in the VBA editor before running.
New Outlook for Windows does not provide the same COM automation interface used by this example. If Outlook is set to the new Outlook experience, a call to create the Outlook.Application object may fail or automation may not be available. Use classic Outlook for this specific method, or consider a supported alternative such as Microsoft Graph or a mail workflow approved by your organization.
Excel for Mac cannot use Windows COM automation with CreateObject("Outlook.Application"). Outlook for Mac and Excel for Mac have different automation options; the Windows code below is not portable to Mac by changing a setting. Excel for the web does not run VBA macros. These limitations matter because “VBA sends Outlook email” is not one identical workflow across all platforms.
Example: make a draft from worksheet addresses
Put email addresses in cells A2 downward on a worksheet named Contacts. The macro skips blank cells, adds each nonblank address as a To recipient, asks Outlook to resolve the list, and displays the message. Change the sheet name, column, subject, and body to suit the workbook. Save a copy of the workbook before running a macro; VBA actions cannot be undone with Ctrl+Z.
Option Explicit
Sub DraftEmailToMultipleRecipients()
' Reads addresses from Contacts column A and displays a draft.
Dim outlookApp As Object
Dim mail As Object
Dim recipient As Object
Dim ws As Worksheet
Dim lastRow As Long
Dim rowNum As Long
Dim addressText As String
Dim allResolved As Boolean
Const olMailItem As Long = 0
Const olTo As Long = 1
Set ws = ThisWorkbook.Worksheets("Contacts")
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
Set outlookApp = CreateObject("Outlook.Application")
Set mail = outlookApp.CreateItem(olMailItem)
For rowNum = 2 To lastRow
addressText = Trim$(CStr(ws.Cells(rowNum, "A").Value))
If Len(addressText) > 0 Then
Set recipient = mail.Recipients.Add(addressText)
recipient.Type = olTo
End If
Next rowNum
If mail.Recipients.Count = 0 Then
MsgBox "No email addresses were found in the list."
Exit Sub
End If
allResolved = mail.Recipients.ResolveAll
If Not allResolved Then
MsgBox "At least one recipient could not be resolved. Review the draft."
mail.Display
Exit Sub
End If
With mail
.Subject = "Meeting information"
.Body = "Hello," & vbCrLf & vbCrLf & _
"Please see the information below." & vbCrLf
.Display
End With
Set recipient = Nothing
Set mail = Nothing
Set outlookApp = Nothing
End Sub
The ResolveAll check is useful but is not a complete email-address validator: a resolved entry can still be outdated, and an address accepted by Outlook can still bounce later. Review the displayed draft and confirm the list before sending. If an address is invalid, correct the source cell and run the macro again rather than assuming Outlook has delivered anything.
Choosing To, CC, or BCC
The recipient type controls how an address appears to other recipients. To is for people expected to act or respond. CC is for people who should be informed and whose addresses can be visible to the other recipients. BCC hides those addresses from the other recipients. In the code, the constants are set on each recipient using its Type property; the values used by Outlook are 1 for To, 2 for CC, and 3 for BCC.
To put a particular address in BCC, add it to the same collection and assign the BCC type rather than the To type. Do not put a large mailing list in To or CC merely because it is convenient: everyone receiving the message may see everyone else’s address. For a message intended as a private announcement to a group, BCC may be more appropriate, subject to your organization’s policies and the message’s purpose.
If recipients need personalized greetings or different attachments, a single message with multiple To recipients is not equivalent to sending separate messages. Each recipient receives the same body and attachments, and visible recipients can see the other To and CC addresses. Create a separate mail item for each person when the content is individualized, and take care not to expose one person’s information in another person’s message.
Using a semicolon-separated To value
For a short, known list, you can assign several addresses in one operation instead of looping over worksheet cells. In a late-bound Outlook mail item, the To property accepts a string of addresses separated by semicolons. You can then call Recipients.ResolveAll and display the draft. This is concise, but it is less convenient if the list must be assembled from a changing range or if each address needs a different recipient type.
Do not use commas as a substitute without checking the format expected by Outlook. The semicolon is the familiar separator for multiple Outlook recipients. Also avoid adding addresses with extra quotation marks around them; quotation marks are not part of a normal email address. If the source list contains a semicolon inside an address field or combines names and addresses inconsistently, clean the source data before building the message.
Display first or send automatically?
The example calls .Display, which opens the message so a person can review the subject, body, and recipients. This is the safer default while developing a macro or working with a list that may change. After confirming the draft, the user can send it through Outlook. A macro can instead call .Send, but that sends without the same deliberate review step and should only be used when the process is controlled and the recipient data has been checked.
Before enabling automatic sending, test with a small list of addresses you control. Check that the correct Outlook account is being used, that the message is addressed correctly, and that the workbook cannot accidentally include an old or unintended row. The sending account may be Outlook’s default account; setting up multiple accounts or choosing a specific sending account requires additional Outlook Object Model handling and should be tested in the actual Outlook profile.
Outlook or organizational security controls may warn about programmatic access or restrict automated sending. Behavior depends on the Outlook configuration, installed security software, and company policies, so a macro should not try to bypass prompts or safeguards. Ask an administrator about an approved method if automated email is blocked.
Common problems and practical checks
- ActiveX component cannot create object: Excel could not create the Outlook.Application COM object. Confirm classic Outlook is installed and configured, and remember that the example is Windows-only and does not target new Outlook.
- Recipient cannot be resolved: Check for leading or trailing spaces, misspellings, empty cells, and stale addresses. The macro trims spaces at the edges, but it does not correct spelling or confirm that a mailbox is active.
- The macro stops at the worksheet line: Verify that a worksheet named Contacts exists in the workbook containing the code and that the address list really begins in A2. Change the worksheet and column references if your layout differs.
- The draft opens but no email arrives: Display only creates a draft. The message must be sent, and sending can still be affected by Outlook being offline, a mail server issue, or a rejected address.
- Nothing appears to happen: Check whether Outlook is waiting for a sign-in, confirmation, or security prompt. Also check Excel’s macro settings and whether the workbook is saved in a macro-enabled format such as .xlsm.
When troubleshooting, start with .Display and a single test recipient, then expand the list. This separates problems with Outlook automation from problems in the worksheet data. Avoid testing a send routine on a real distribution list: an accidental message may be difficult or impossible to retract.
Privacy, volume, and alternatives
VBA does not remove the limits or responsibilities associated with email. Mail providers and organizations can impose sending, recipient, or rate limits, and those limits vary by account and policy; there is no universal safe recipient count for every Outlook setup. Large or repeated mailings may be throttled, rejected, or treated as bulk mail. Use an approved mailing platform for newsletters or high-volume communication, and follow consent, privacy, retention, and internal communication rules that apply to your situation.
For modest internal tasks, Excel VBA with classic Outlook can be useful because it connects an existing workbook list to a draft. For cross-platform or server-side automation, Microsoft Graph or Power Automate may be more suitable, but those options require their own permissions, setup, and organizational approval. They are not drop-in VBA replacements: the right choice depends on where the automation runs, who maintains it, and how many messages it needs to handle.
Frequently Asked Questions
Can I put multiple email addresses in the VBA To field?
Yes. A semicolon-separated string can be assigned to Outlook’s To property, or you can add each address separately to the Recipients collection. Adding them separately is generally easier when the list comes from worksheet rows or uses To, CC, and BCC categories.
How do I send one email to many people without showing their addresses?
Add the recipients as BCC rather than To or CC, then review the draft before sending. BCC hides those addresses from the other recipients, but it does not personalize the message; everyone still receives the same content.
Can Excel VBA send email without Outlook?
Not with the Outlook Object Model code shown here. Other approaches, such as Microsoft Graph or a mail service, can send mail without automating classic Outlook, but they require a different implementation and appropriate account permissions.
Does this macro work with new Outlook or on a Mac?
No. It uses Windows COM automation for classic Outlook. New Outlook does not expose the same COM interface, and Excel for Mac cannot create a Windows Outlook COM object. Use a platform-appropriate, supported alternative instead.
Why does Outlook ask me to confirm or block the macro?
Programmatic access may be controlled by Outlook security, antivirus software, or an organization’s policy. The exact behavior varies by setup. Do not bypass the protection; ask your IT administrator which automation method is approved.
Related
- Power Query Remove Leading Zeros Without Losing IDs
- Power Query Reference: What It Does and When to Use It
- Excel Data Validation: Can You Select Multiple Items?
Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.
More in VBA & macros
- Excel VBA Module: How It Works, Types, and When to Use OneAn Excel VBA module is a container for Visual Basic for Applications code, such as macros, helper procedures,…
- Excel VBA Copy and Paste Range: Examples and TipsIn Excel VBA, copy a range to another location with sourceRange.Copy Destination:=destinationRange. For values only, assign the ranges…
- VBA MsgBox: How to Display a VariableYes. To display a VBA variable in a message box, join it to a text string with the…
- VBA Close Workbook Without Saving: Methods and RisksTo close an Excel workbook with VBA and discard its unsaved changes, call the workbook’s Close method with…
- VBA Coding Dictionary: How the Dictionary Object WorksA VBA Dictionary is an object that stores pairs of keys and values, letting an Excel macro look…
- Excel VBA: Create a Word Document from a TemplateTo create a Word document from an Excel VBA macro on Windows, use Word’s automation object to open…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.