Hi
On my worksheet I have email addresses in column A and text in column B. Not all cells will have an entry in column B. These are results generated from a separate sheet using a formula
Is there a formula I can use to launch the email address via gmail if Column B contains specific text?
i.e. if B1 contains the word "action", then open an email in gmail to the address specified in A1?
Might be a long shot but any help would be appreciated
On my worksheet I have email addresses in column A and text in column B. Not all cells will have an entry in column B. These are results generated from a separate sheet using a formula
Is there a formula I can use to launch the email address via gmail if Column B contains specific text?
i.e. if B1 contains the word "action", then open an email in gmail to the address specified in A1?
Might be a long shot but any help would be appreciated
