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.
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.)
How to send emails
0
Discussion
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
Answers
0
You will need to do two things:
Loop through a Range of Cells in Excel VBA/Macros
Both links have sample code that should get your started in your project.