Hi
I have a piece of code which i use to drive an e-mail from a form
Dim strEmail As String
Dim strmessage As String
DoCmd.SetWarnings False
strEmail = "MyE-mail"
strmessage = Title & " " & SirName & " Account No " & txtAC & " has called to cancel there Service Because They are Moving To A Non Serviceable Area on " & MoveDate & " New Details are House Number " & HouseNo & " Postcode " & PostCode & " Contact Tel " & Cont1 & " Mobile " & Cont2 & "."
DoCmd.SendObject , "", "", strEmail, "", "", "Non Serviceable", strmessage, False, ""
My question is how would i seperate this so that each field appeared on a seperate line?
I have a piece of code which i use to drive an e-mail from a form
Dim strEmail As String
Dim strmessage As String
DoCmd.SetWarnings False
strEmail = "MyE-mail"
strmessage = Title & " " & SirName & " Account No " & txtAC & " has called to cancel there Service Because They are Moving To A Non Serviceable Area on " & MoveDate & " New Details are House Number " & HouseNo & " Postcode " & PostCode & " Contact Tel " & Cont1 & " Mobile " & Cont2 & "."
DoCmd.SendObject , "", "", strEmail, "", "", "Non Serviceable", strmessage, False, ""
My question is how would i seperate this so that each field appeared on a seperate line?