Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to send emails


We have A,B,C....up to z Stores they will do the Audits on regular Basis.

We need to send emails for variances, is there a way we can send in one click.

All Variances will be in one sheet with store Name.



Look at the links on the left of your screen. You will find guidance there.
Variatus (rep: 4889) Jun 28, '20 at 6:11 am
Add to Discussion



You will need to do two things:

Loop through a Range of Cells in Excel VBA/Macros

Send Emails from Excel

Both links have sample code that should get your started in your project.


Answer the Question

You must create an account to use the forum. Create an Account or Login