Send multiple emails from Excel(XLMultimail Ver 2.0)

XLMultimail updated to 2.0.0 version on February 27, 2022.

  1. If you select 'NO' for the mail body font setting, you can use the default font set in Outlook.
  2. You can send emails on behalf of another person.

 


How to use the program(XLMultimail)

You can send multiple emails with customised contents and attachements from Excel through Microsoft Outlook using this VBA program.

For example, you can send multiple emails at once if you want to notify the amount of overdue for each recipients.

Send emails in the following order...

1) Enter the subject and the body of the mail.

In the 'Mail Contents' sheet, If you want to change the subject of the mail for each mail recipient, type {1}, {2}. The VBA program replaces {1}, {2} by using replaceable values from 'Mail List' tab.
You can enter the mail body in the same way.
Sending Mail from Excel with Microsoft Outlook

 

Results when {1}, {2} ... are replaced

Sending Mail from Excel with Microsoft Outlook

 

2) Enter email address and replaceable values

In the 'Mail List' tab, enter the email address of the recipient and replaceable values.
Sending Mail from Excel with Microsoft Outlook

 

3) Enter attach file names

To attach files to the email, enter the file path of the attachments where the attachments are located as shown in the following image. It should be entered in the form of 'folder name \ filename'.
Sending Mail from Excel with Microsoft Outlook

You can find the folder location as follows. Go to the folder where the file is located, select any file, right-click the mouse, and select 'Properties' in the window that appears. In the General tab, the location refers to the 'folder location'.
Sending Mail from Excel with Microsoft Outlook

 

4) Send mail

Click the 'Send mail' button on the 'Mail from Excel' tab of the ribbon menu.
* If you want to preview the contents of the mail before sending it, click the 'Preview' button.

send email from Excel ribbon menu

 

VBA program password  : 'xlworks'

 

1 thought on “Send multiple emails from Excel(XLMultimail Ver 2.0)”

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top