Hi, im looking to add a signature to my email that get created by values etc within excel and run using a button, the code im using for the button is
Sub SendEmailprop()

    Dim OutlookApp As Outlook.Application
    Dim MItem As Outlook.MailItem
    Dim cell As Range
    Dim Subj As String
    Dim EmailAddr As String
    Dim Recipient As String
    Dim Msg As String
    
    Set OutlookApp = New Outlook.Application
    Msg = Msg & Range("B8") & vbCrLf
    Subj = "Mortgage Application "
    
    Set MItem = OutlookApp.CreateItem(olMailItem)
    With MItem
        .To = Range("B4")
        .Subject = Subj & Range("B6")
        .Body = Msg
        .Display
    End With

End Sub
using http://www.rondebruin.com/win/s1/outlook/signature.htm code it creates an email with a signature but all my values which i've formatted and are changed depending on selection from drop down boxes in the worksheet are clunked together in one big paragraph instead of bullet points etc.

any help appreciated