How to Send Bulk Emails with Different Attachments from Excel?

Prepare the Email Data in Excel

Before sending the emails, organize your mailing information in Excel. For example, I prepare the following data, such as: Name, Email Address, Subject, Body, Attachment path.

Method 1: Send Bulk Emails with Different Attachments Using VBA

If you are comfortable using VBA and have Microsoft Outlook installed, you can create a macro that reads each row in Excel, creates an Outlook email, attaches the corresponding file, and sends the messages automatically.

1. Prepare the Worksheet, suppose your worksheet contains the following columns:
   
2. Press Alt + F11 to open the Microsoft Visual Basic for Applications window.
3. Then, click Insert > Module, and copy and paste the following code into the module:

Sub SendEmailsWithDifferentAttachments()
    Dim OutlookApp As Object
    Dim OutlookMail As Object
    Dim ws As Worksheet
    Dim LastRow As Long
    Dim i As Long
    Set ws = ActiveSheet
    LastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row
    Set OutlookApp = CreateObject("Outlook.Application")
    For i = 2 To LastRow
        Set OutlookMail = OutlookApp.CreateItem(0)
        With OutlookMail
            .To = ws.Cells(i, "B").Value
            .Subject = ws.Cells(i, "C").Value
            .Body = ws.Cells(i, "D").Value
            
            If ws.Cells(i, "E").Value <> "" Then
                .Attachments.Add ws.Cells(i, "E").Value
            End If
            .Display
        End With
        Set OutlookMail = Nothing
    Next i
    Set OutlookApp = Nothing
End Sub

4. Press F5 key to run the macro. Excel will process each row in the mailing list and create a separate Outlook email for each recipient, automatically filling in the corresponding email address, subject, message, and attachment.
   
5. Review the generated emails carefully, then click Send button for each message one by one.

Method 2: Send Bulk Emails with Different Attachments Using Kutools for Excel

If you prefer a simpler solution without writing or maintaining VBA code, Kutools for Excel provides a convenient Send Emails feature that lets you send personalized bulk emails directly from an Excel mailing list.

You can map worksheet columns to the To, Cc, Bcc, Subject, and attachment fields, insert placeholders for recipient names or other personalized information, and assign different attachments to different recipients. With just a few settings, Kutools can send individualized emails in bulk through Microsoft Outlook or your own outgoing mail server.

Step 1: Prepare the Mailing List

Create a worksheet containing the information required for your emails, such as the recipient name, email address, CC address, subject, message information, and attachment path.

Step 2: Select the Mailing Data

Select the data range containing your mailing list. Then click Kutools Plus > Send Emails.

The selected range will be automatically populated into the mailing list area of the Send Emails dialog box.

Step 3: Map the Email Fields

In the Send Emails dialog box, map the corresponding worksheet columns to the email fields:

• To: Select the column containing the recipient email addresses.
• Cc: Select the CC column if needed.
• Bcc: Select the Bcc column if your mailing list contains one.
• Attach files: Select the column containing the attachment file paths.
• Subject: Select the column containing the email subjects.
  

Step 4: Compose and Personalize the Email Body

Compose the email body in the message editor. To personalize the message, select a worksheet field from the drop-down list and click Insert Placeholder.

For example, inserting the Name field allows you to create a personalized greeting such as:

When the emails are sent, Kutools automatically replaces the placeholder with the corresponding name or other information from each row of the mailing list.

Step 5: Choose How to Send the Emails

Kutools for Excel allows you to send emails either through Microsoft Outlook or through your own outgoing mail server.

Step 6: Send the Emails

Review the field mappings, attachment settings, and email content. Then click Send.

Kutools will process each row in the mailing list and send a separate personalized email to each recipient with the corresponding recipient address, subject, CC/Bcc information, message content, and attachment.

If you send the emails through Outlook, you can open Outlook after sending and check the Sent Items folder to confirm the sending status and verify that each message contains the correct personalized greeting and attachment.

VBA vs. Kutools for Excel: Which One Fits Your Workflow Better?

Both methods can send personalized bulk emails with different attachments, but they are better suited to different types of users and workflows. The table below highlights the main differences.

Important Notes Before Sending Bulk Emails

Frequently Asked Questions

Conclusion

Sending bulk emails with different attachments from Excel can save a significant amount of time when distributing invoices, reports, certificates, statements, contracts, or other personalized documents.

For advanced users, VBA with Outlook provides a flexible way to automate the entire process. Excel stores the recipient information and attachment paths, while the VBA macro creates a separate email for every row.

For users who prefer a simpler approach, Kutools for Excel makes it easier to create personalized bulk emails without writing or maintaining VBA code. You can map worksheet columns to recipients, subjects, messages, attachments, CC, and BCC fields and send individualized messages in batches.