Email Module - Excel 365

Email Module Created Using Excel VBA - Office 365:

I have created this Excel Macro-Enabled Workbook based on my experience in my work as I needed to automate the daily MIS process to be published to the management and the stakeholders without any delay, therefore I came up with this Module to smooth the transition.

What you can do using this file?

You can send an email directly from your Excel file

You can add a list email addresses in the To section using the Excel unique and TextJoin formula that is available in the configuration sheet

Email address validation for all email addresses that you have added in the configuration sheet "ex. Remove spaces and exclude emails that not following the email address format, if it is missing dots or @ sign"

You can include up to 2 Excel tables inside your email body

You have the option to choose whether you want to include both tables or one table to your email body

You can add attachments by specifying the attachment's file location in the configuration sheet

This Emaiil Module is compatible to work on Office 2016 up to the latest versions of Office.

To configure the file to work on your system, please follow the below steps:

1- Press Alt + F11 from your keyboard to access the VBA window.

2- From Tools then click on references from the menu

3- Select the below references :

A- Microsoft Outlook 16.0 object library

B- Microsoft Word 16.0 object library

The versions above will be different based on the office version that you are currently using it