How to Automatically Send Emails With HTML Tables Using Excel VBA Macros

In this tutorial we would learn
1. How to Send Outlook Emails From Excel
2. How to Send Emails With HTML Body

[@deepakbhatia8839]

Nice informative and helpful video.

[@AutomationMadeEasy]

Glad it was helpful!

[@Amit-q5c]

How to make it dynamic for multiple employee to send for their data individually. Where each employee keeps more than 5 records data to be shared

[@kamalsharma-xt8vc]

Hi, Thanks alot for makong such knowledgeable vidoes. I am curious to know how to add the signatures and logo. I would be glad if you could assist me

[@hafizshareef306]

My code is running fine but it is not taking formate of template

[@user-rs6zu5re7t]

Hi i have written the code and it is running with out error. Also checked email address is correct. But i am not able see email in inbox also in send items. Please help

[@AutomationMadeEasy]

seems the code which is sending mail is not being reached, it may be outside of the loop. Check loop indexes

[@dannybejjani]

Thank you for this wonderfull tutorial, but what if I want to send the header and the last entered row in a table?

[@AutomationMadeEasy]

well that will need some coding where you will use only the header row and the last row in the excel to get the desired data

[@Dani4Seo]

thank you men!

[@AutomationMadeEasy]

Welcome!

[@patilmillind7987]

I tried this code but my table has taking value for fist two header and for remaining header its not taking value from excel. Could you please help?

[@AutomationMadeEasy]

i need to see your code and data sheet

[@jayantopaul2418]

Can u please show how to use the same code and add multiple tables in the body of the email

[@christineadamsdayrit2319]

Why do I receive an error: Variable not defined from Strsubject line?

[@AutomationMadeEasy]

if ur script has option explicit in the begining, please remove it

[@christineadamsdayrit2319]

Bighelp! It worked

[@kritijain1291]

Hi, Thank you for the video. Can you please explain this syntax how it will work ".Cells(Rows.Count, 1).End(xlUp).Row"

[@AutomationMadeEasy]

this will give u total number of rows.

[@Dhanushibharatsingh]

Could you please help me with the website link wer we can refer to the code

[@AutomationMadeEasy]

automationandagile.com

[@sameerwagh409]

Pls share the code

[@AutomationMadeEasy]

its available on the blog automationandagile.com