How to use VBA to send emails from Excel? [Closed]


I really need some help!
I need to create a macro which will send emails to a specific email address within excel when a cell is updated.

Columns are:
C - Email address (where I want the email notification to go)
D - Persons name
L - Query status (this will be either 'Pending' or 'Closed'

When the query status is changed to pending or closed, I need an email to be sent to the email address in column C to notify them that their query has been updated.

Can the macro also run when the query status is changed, rather than having to run the macro manually?

Any help will be much appreciated!!
Thanks :)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!