VBA Code to Send an Email

[seasmith]

Hi all, I am working on a spreadsheet that has a button at the top with the date next to it. I want to be able to click the button and have it check the date next to it to see if it has been a month since last clicked and if it has then I have two columns Relief Valve # and Test Date. I have conditional formatting that will turn the Test Date red if it has to be tested. I want the button to find the red test dates and send an email message that finds the red test date and the relief valve # that is with the date and send a message "Relief Valve # is due by whatever date"

I'm not sure if this is even possible or not but any help on where to start or anything at all is greatly appreciated.

 

[VoG]

This may be a start http://www.rondebruin.nl/mail/change.htm

 

[seasmith]

Thanks for the link! I'll test it out and see what I can do with it. I'll let you know how it goes

 

[seasmith]

The code from the link worked great! But I have one column called relief # and a column called date tested. I need the code to go thru the date tested column and find the dates that are in red due to conditional formatting and if the text is red it goes to the relief # column and puts
Relief # such and such needs to be checked.

Any help with this would be great!