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?