Send automatic email when a cell changes in excel 2010

[Poolshark25]

Hi all

I have a training spreadsheet and want to send an automatic email to a manager when a cell D9 changes to "Retrain" in the column D "Status"

Cell C9 holds the managers email address manager@email.com

I need the following in the email:

• email address of the recipient
• Subject: Training Required
• Content: Employee ??? is now due further raining on "Pesticies", please arrange this to comply with company policy

Regards

Traning Adminisrator


Is there a way the spreadsheet can be coded to automatically generate and send the email to the manager once the cell in D9 changes to read "Retrain"?

I am using Windows 10 and Outlook

I would grateful of any help wit this please

 

[Rijnsent]

Hi Poolshark,
check out the site of Ron de Bruin, he has quite some tutorials on emailing with VBA from Excel e.g. : https://www.rondebruin.nl/win/s1/outlook/bmail4.htm
To start a macro, code like this could be used:

 Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Target.Worksheet.Range("B1")) Is Nothing Then

      Call macro

    End If

 End Sub

Cheers,
Koen

 

[Poolshark25]

Hi Koen

Many thanks for the link and the advice. I will give it a try.

Regards,

Ernie