Include unsubscribe mailto link vba email body

[Robinom]

I have the usual send to (olMail.To), subject (olMail.Subject) and body (olMail.Body) of an email to be generated by an excel macro. The last line of text in the body (xStrBody) reads ”To unsubscribe click ”. I want to append the word “here” with a link to a return mailto such as “mailto:membership@gmail.com?subject=Unsubscribe”. I can’t find the syntax to do this anywhere. Is anyone able to help?

 

[Domenic]

Try . . .

"To unsubscribe click <a href='mailto:membership@gmail.com?subject=Unsubscibe'>here</a>"

Hope this helps!

 

[Robinom]

Perfect. Thank you!!