VBA Sending Outlook emails

[Andrada_Kio]

Hi Guys,

I have a VBA that send automatic emails from excel, but I have a problem with formating and Hiperlink. In the Sheet "_Text" is the email with all the detalis that I need, Bold, Hiperlink...

Can anyone help on this , please!!

The file is on the link below!

https://gofile.io/?c=WZ5iwB

Thank you in advance.

 

[MPaul100]

First of all, why using a shape for text? There are simpler ways to send this email and keeping the text formats and hyperlinks. Also, posting on a forum with your facebook profile embedded into a hyperlink is not a good idea. And the macros are a headache

 

[Andrada_Kio]

Thank you , Paul for your help