Mass mails are a direct and effective means of communication to transmit a message to a group of contacts. If you want to send a mass email to a group of people using Excel, we recommend you read this article because with it you will learn how to send mass emails from Excel with attachments
How to send mass emails from Excel with attachments.To create a guide for sending mass emails from Excel with attachments, it’s important to follow a step-by-step process. Here’s a tabular guide to help you through the process:
| Step | Description |
|---|---|
| 1. Prepare Excel Sheet | Create an Excel sheet with columns for Email Address, Subject, Message, and Attachment Path. Enter the details for each recipient in these columns. |
| 2. Enable Developer Tab | In Excel, go to File -> Options -> Customize Ribbon. Check the “Developer” tab and click OK. |
| 3. Open Visual Basic Editor | In the Developer tab, click on “Visual Basic” to open the editor. |
| 4. Import References | In the editor, go to Tools -> References and add references to “Microsoft Outlook XX.X Object Library” (where XX.X corresponds to your version of Outlook). |
| 5. Write VBA Script | Create a new module and write a VBA script to loop through each row in your Excel sheet and send emails using Outlook. Include code to attach files from the specified attachment path. |
| 6. Test the Script | Run the script in the Visual Basic Editor to test sending emails. Ensure Outlook is configured and running. |
| 7. Execute Mass Emailing | Once tested, execute the script to send emails to all listed recipients. |
| 8. Verify and Follow-up | Check your sent items in Outlook to confirm the emails were sent. Follow up on any undelivered emails. |
This guide assumes you have basic knowledge of Excel and VBA programming. Always test your script with a small group before sending out mass emails to ensure everything works as expected. Additionally, be mindful of the legal and ethical implications of sending mass emails, and ensure you have permission to email the recipients.
We can often send attachments from our mail . However, we can send mass emails from Excel with attached files using an address list, a message of interest to the recipients and a macro . Next, we explain the steps you must follow to comply with this procedure.
Create the email window
Enter Excel and in a new spreadsheet write in cell A2 “To:”, in cell A3 “CC:”, in cell A4 “CCOO:”, in cell A5 “Subject:”, in cell A6: “Message:” and in cell A7 “Attachment:” (all without the quotes)
In cell B2 you will enter the recipient’s email, in cell B3 the desired email with a copy, in cell B4 you will write the desired email with blind copy, in cell B5 you will write the title or subject of the message, cell B6 will be available for write the mass mail and in cell B7 you can attach a file.
Compose your message
Write a message that grabs the attention of your recipients. To do this, place the cursor in cell B6 and if you need to make line breaks you must press the “Alt + Enter” keys.
Add the attachment
To add the attachment, place your cursor in cell B7. Make sure to type the exact location of the file as well as its extension.
Create the macro from Excel
To create the macro you must press the “Alt + F11” keys. Then the Visual Basic Application editor will open. Go to the “Menu”, click “Insert” and “Module”. Then select “Module1”. You will immediately see a window where you must add the following code (The points are only indicative of each line, they should not be included in the code):
- Sub mail_adjoint ()
- Dim mail As Object
- Dim app As Object
- Set app = CreateObject (“Outlook.Application”)
- app.Session.logon
- Set mail = my_App.CreateItem (0)
- ActiveWorkbook.Save
- On Error Resume Next
- With mail
- .To = Range (“B2”). Value
- .CC = Range (“B3”). Value
- .BCC = Range (“B4”). Value
- .Subject = Range (“B5”). Value
- .Body = Range (“B6”). Value
- .Attachments.Add Range (“B7”). Value
- .DeleteAfterSubmit = False
- .Send
- End With
- MsgBox “The message has been sent”
- On Error GoTo 0
- Set app = Nothing
- Set mail = Nothing
- End Sub
Save the file
Click the start button and select “Save As”, type a name that identifies the file and assign the extension .xlsm to enable macros .
Insert a button to the spreadsheet
You should go to the “Developer” tab, click on “Controls” and “Insert”. Select “Form Controls” and press “Button.”
Use the mouse to draw a rectangle, click on the element and change its name to “Send”. In the window for assigning a macro, click on “email_adjoint” under “Macro name” and press the “OK” button.
Add the reference
Enter “VisualBasic” again from Excel by pressing the “Alt + F11” keys. Go to “Tools” and “References”. There, check the box “Microsoft Outlook XX Object Library”, where “XX” is the version of the Excel application. Then press the “OK” button.
Run the macro
Write all the values of the mass mail and execute the macro by clicking the button . Finally, you will see a confirmation message after the shipment has been made.
