Hi i have a rather long message in my MsgBox but i want the email address to either be blue to stand out or linked so that the user can click on it and it will open up outlook with the email address already in the recepitent box. Is this possible?

Private Sub email_Click()

Dim resp

resp = MsgBox("Click yes if you would you like to view help for the cost model? Or click no email the cost model along with an issue/query? Or click cancel to return", vbYesNoCancel + vbQuestion)

If resp = vbNo Then
 '
 ' email Macro
 '
 '
 '
 ActiveWorkbook.Save
 'Optional parameters for xlDialogSendMail are: Recipients, Subject,
 Application.Dialogs(xlDialogSendMail).Show "DanielS@ChingfordFruit.co.uk", "Cost Model Query"
End If
 
If resp = vbYes Then
MsgBox "Please make sure you have done the following:" & vbCrLf & vbTab & "" & vbCrLf & vbTab & "1. Enter Category & Customer in cells C1 & C2?" & vbCrLf & vbTab & "2. Enter all information required in the part input box?" & vbCrLf & vbTab & "3. Filled all required entries in blue cells & packhouse info section?" & vbCrLf & vbTab & "" & vbCrLf & vbTab & "If you still require further help please email or contact Daniel Schofield" & vbCrLf & vbTab & "" & vbCrLf & vbTab & "Email. DanielS@ChingfordFruit.co.uk" & vbCrLf & vbTab & "Tel. 01322 429 232"
End If

End Sub