Formatting paragraph into html and copy to clipboard for email

[Gaurangg]

Hi All,

I am trying to write a paragraph into vba code along with some formatting as I want to write some lines in bold, double line break, give hyperlink to email address and at the end I would like to copy entire paragraph into clipboard so I can paste it manually on email body. I am completely unaware about html code so took help from some threads and could do only as below. anyone can please help in this to complete the code?

I would like to write as

Hi John,

Please find below the required information.

Description: (Bold)

Name:
Address:
DOB:
Email: xxxxx@gmail.com (Hyperlink)

Thanks

Sub Mydata()
Dim s As String
s = "<font size=""10"" face=""Calibri"" color=""black"">" & _
    "Hi John" & "<br>" & _
    "Please find below the required information" & _
    "Description:" & _
    "Name:" & _
    "Address:" & _
    "DOB:" & _
    "Email: xxxx@Gmail.com" & _
    "Thanks:" & _
    "</font>"
End Sub

 

[AFPathfinder]

Posting HTML code in these forums is a bit weird, but I'll post some examples.

Bold:

<b>Description</b>

Carriage returns:

"Hi John,<br /><br />Please..."

Mailto hyperlinks:

<a href=""mailto:xxxxx@gmail.com"">xxxxx@gmail.com</a>

The HTML goes right inside the quotations in VBA as if it was text and then you'll use the HTMLBody syntax to insert into an email.

For HTML syntax, I use this website to get me going: http://pbar.fnal.gov/htmlref.html

 

[AFPathfinder]

I guess the carriage returns didn't make it through the post, but you can see those examples on that website in my previous post.