1. SENDING BULK EMAILS DIRECTLY FROM EXCEL

{}{}{} Please enable captions: ON {}{}{}
1:45 MACRO 1. SEND BULK MAIL WITH ONE ATTACHMENT
4:25 MACRO 2. SEND BULK MAIL WITH MULTIPLE ATTACHMENTS
6:55 MACRO 3. SEND BULK MAIL WITH MULTIPLE ATTACHMENTS AND FORMATTED MESSAGE
8:13 MACRO 4. SEND BULK MAIL WITH FORMATED MESSAGE AND MORE ATTACHMENTS
9:39 BULK MESSAGES SENDING I.E. 100 MESSAGES SENDING AT ONE CLICK
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
If anybody feels destined to try or test the execution, please let me know, and
I will be humbled and delighted to share the VBA Macro Codes that have been used.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Welcome to Ever Learning Bloomer TH-cam Channel, where learning never stops, no matter THE AGE!
Hello Excel VBA Fans,
In this video, I’m excited to share a simple yet powerful Excel VBA project that automates sending emails directly from Excel without manually composing messages in Microsoft Outlook.
Let’s dive in!
First, let’s check my Microsoft Outlook.
My last sent message is dated 22nd November.
You notice the time and date.
Now, I’ll open my workbook named SEND MAIL.
It seems, my excel application has got error on opening,
you might notice some error prompts or messages -
nothing to worry about.
The workbook named SEND MAIL contains a SendMail sheet, which serves as the template for this project.
You will observe the Key fields in Columns A to G, which handles email automation.
You will also observe that On the Excel ribbon,
you’ll find a custom tab titled Send E-mail, added for convenience.
This tab includes four macros:
Macro 1 helps SEND Bulk MAIL WITH ONE ATTACHMENT:
You closely observe the working.
After entering "1" in the Email Count prompt,
the status in Column G updates to "Sent 1 time.
Macro 2 helps SEND Bulk MAIL WITH MULTIPLE ATTACHMENTS:
Adding paths for three additional attachments in the sheet sends an email with four attachments.
Macro 3 helps SEND Bulk MAIL WITH MULTIPLE ATTACHMENTS and FORMATTED MESSAGE:
Now, you will observe that I am Using the same four attachments, this macro customizes the message format with font colors and larger text for better readability and visibility.
Macro 4 helps SEND Bulk MAIL WITH FORMATTED MESSAGE AND MORE ATTACHMENTS:
This project was developed as a hobby, and while I’m not an expert in Excel VBA, I hope it proves helpful to beginners and anyone looking for similar solutions. Let me know your thoughts, and feel free to share your experiences in the comments.
Since, I am just doing as a hobby, I will not mind accepting as many tips and advices as possible for my learning from all sources.