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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Include unsubscribe mailto link vba email body
- Thread starter Robinom
- Start date
-
- Tags
- unsubscribe
Excel Facts
Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Similar threads
- Replies
- 1
- Views
- 132
- Question
- Replies
- 3
- Views
- 549
- Solved
- Replies
- 1
- Views
- 845
- Replies
- 1
- Views
- 802
