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
Bookmarks