Send email when 2 cells contains specific text.

[jurgen010]

Hi there friendly people,

I'm trying to make a VBA formula to send an email based on specific text in 2 specific cells.

ie.
If the cells in colomn $A contains "example1" AND if the cells in colomn $Q contains "example2" then send an email to all email adresses in colomn $W.

I've got an example of something similar, but it's based on "if cell x is smaller then cell y then send mail to.

Please Login or Register  to view this content.

I hope someone can provide me with an example. So i can get an promotion on my work :-)

Much apreciated.

[ARowbot]

Are you wanting this to happen on change of a cell in column A or Q. Or to run down all cells in them columns and then send the email?

You can use this to check if a cell contains a string:

Please Login or Register  to view this content.