Avatar of onaled777
onaled777
Flag for United States of America asked on

excel macro to send email based on cell value

Hi experts
I have a spreadsheet that tracks the attendance, each month has its own tab, the name of the employee is in cell i3 that happens to be a merged cell, there is a running calculation of points and different levels of actions that are taken when certain levels are reached, this is my question I want macro to send an email once a certain level is reached; ie when m2 = written or above an email is sent, I need thi from the sheet labeled FEB10.  I am using excel 2007 & outlook 2007. Attached is a copy of the spreadsheet. Thanks again for any help

Book2yyy.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
onaled777

8/22/2022 - Mon
onaled777

ASKER
PS the mail title should read "\"employee name" is @ a corrective action level.  The body of the email should have the name, the value in cell M2. the email will be need to sent to about 3 people
Robberbaron (robr)

how do you want to trigger the sending of message ?
easy& most controlled is to have the user press a button to send all messages.  Or can use the On_change event for the cell.

I'll post some code shortly but you should read http://support.microsoft.com/kb/161088 for info.
ASKER CERTIFIED SOLUTION
Robberbaron (robr)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
onaled777

ASKER
ok thanks for responce i am reviewing the code now
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck