I have built an email macro, that i need to have the mailto: address change based on a cell value, I can set a string, then build the formula using an IF statement but with the
I dont see where to place it, i can put it in the "mailto:, but then it will think thats the email address. Any help would be appreciated.![]()
URL = "mailto:" & Email & "?subject=" & Subj & "&body=" & Msg
Bookmarks