Excel VBA - Send Excel Tables via Outlook Emails

Requirement :
Client wants a VBA that will send table from Excel via Email. He will provide the excel file with list of emails and items to be included in the email.

Features :
- 1 Click to send out the emails
- Customizable to the any number of emails needed to be sent
- Customizable Email Subject, Email Content

Client Feedback :
W is very helpful in guiding me to prepare the data, and I am able to get the exact result that I want. I used to send out 40+ emails manually in the past every week, and now I can finish this in just 5 minutes.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
For any projects or questions , feel free reach out to me as below!

[andrealmeida_]

Thank you! This is very helpful. Thanks for the code!

[helloworldguru]

Many time i watched but I couldn't understand 😭

[Darshanam-Jatra]

thanks for this powerful yet simple flow
see if you can twist a bit with header row only as first row
amd not expected with each new email id as most of the live data has only one header row

[shefalijain]

Hi while trying to run this code, I am getting this error. Can you help
Select method of range class failed.

[VuTrungKienFPLHN-omkp]

Watching the video, I still find it difficult to refer to the emPL software that sends receipts and salary slips automatically via email or Zalo.

[dr.strange]

how do you creat a button like yhe one that said Send out Email? i want to create a Paste button within Excel that allows me to copy date from an email and paste it accordingly in Excel specific data labels.

[karolbarszcz]

Do you know how to add tables to email generate in MS Access?