E-mail Formating

delboy2

Registered User.
Local time
Today, 06:46
Joined
Oct 10, 2003
Messages
12
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?
 
Put this between each element you want on a different line:
Code:
& vbCRLF &
 
Thanks
Thats a great help
 

Users who are viewing this thread

Back
Top Bottom