Auto Send Email based on Cell Content

[tigerdel]

I am trying to get an email to automatically be produced and sent if Cell in Column U contains the words "Send Reminder"

I have attached the spreadsheet and the code I have been working on [from Ron Bruin site]for the email which I cannot get working

Also not convinced it would send automatically when the cell changes to contain required phrase

I'd be really grateful for some help with explaining what I have done wrong

Please Login or Register  to view this content.

Spreadsheet is here: Contacts List.xlsm

Thank you so much for helping

[Winon]

Hello tigerdel,


See this link: http://www.excelforum.com/excel-prog...excel-vba.html

Regards.

[davesexcel]

There are 13 character in the string "Send Reminder", that may be why the e-mail is not kicking in. Your code is asking 12 `Left(Cells(i, 21), 12)`, change the 12 to 13