VBA outlook - Add email address hyperlink into html body

[picklechips]

Hi all,

I have a macro that opens an outlook email and attaches documents/puts a blurb in the email body.

I wanted to put a hyperlink in the body of a persons email address, so the receiver should be able to click on the hyperlink and it opens a new email with the "To:" being the email address in the hyperlink.

Below is my .html body code which gets the hyperlink to show up in the email body (blue underline) but when people click on it, nothing happens. Any idea how to make it so a new outlook email opens like when you usually click on an email address hyperlink? .

Thanks in advance!
Pickles


PS. Had to replace the sideways arrows below with square brackets for it to not remove parts of the code.

.HTMLBody = .HTMLBody & "[p]Salesperson 1 [a href=""salesperson1@hotmail.com""] salesperson1@hotmail.com [/a] T – 647 868 1234 [/p]"

 

[smozgur]

Try putting "mailto:" right before the email address in the href attribute.

.HTMLBody = .HTMLBody & "[p]Salesperson 1 [a href=""mailto:salesperson1@hotmail.com""] salesperson1@hotmail.com [/a] T – 647 868 1234 [/p]"

 

[picklechips]

Thank you kind sir. Now they can open a new email by holding Ctrl and clicking the hyperlink.

Do you know if theres a way to simly click the hyperlink to open an email instead of having to hold Ctrl and click?


Thanks,
Pickles

 

[picklechips]

Hi never mind, it actually opens an email with one click (no need to hold ctrl).

I think in the email preview it made me have to hold ctrl to open an email.


Thanks again,
Pickles