Preserve Hyperlinks Using rangetohtml excel to outlook vba code

[Pang_george]

I have a range identified and when I run the vba, the range I defined shows properly in the oulook email.

However, data in my first column has hyperlinks but the hyperlinks had not been preserved.

I tried adding the code User KDY suggested in the link below but still, the hyperlinks do not work:

https://www.mrexcel.com/forum/excel-...e-outlook.html

Just an FYI - my column with hyperlinks uses the function =Hyperlink(Link Location, Friendly Name) for each row.

How can I make this work?

[Leith Ross]

Hello Pang_george,

The problem may be what your hyperlinks are referring to. Most times, hyperlinks in email direct you to another site. If your hyperlink is directing to you to place in the workbook, the hyperlink won't function until the workbook is opened. Publishing will include both formula created hyperlinks and web links.