Copy/Paste Hyperlinks in Outlook using Macro

[Hyprosick]

Hi,

I am using rondebruin's code to copy a range or selection from Excel to the body of an outlook email. I understand it uses the Paste Special Values to paste the data. I am currently using a pivot and different lookups to return the data I want and is sent out to specfic individuals with their assigned projects and each project is Hyperlinked to the file location. If I simply select all the cells and Copy Paste into the Outlook email the Active Hyperlinks transfer with it. I dont know anything about coding, just enough to have a simple understanding of what the code is doing. Is it possible to edit or a simple fix that would allow me to use a macro to copy all visible cells in a set range/selection and paste it to an outlook email without losing the hyperlinks?

Thanks

Brett

[Burry]

Enstead of copy and past for Outlook you can use www.clicktoapp.com