easy for you

JUDO

Registered User.
Local time
Today, 02:39
Joined
Aug 21, 2003
Messages
26
in the code below how can i make "Regards Roly" start on a new line.

DoCmd.SendObject , "", "", "mkingscote@stanmar.co.uk", "", "", "Forecast Required", "Please forecast part number " & Forms![stanmarfrm]![part number] & " " & Forms![stanmarfrm]![DESCRIPTION] & " on order " & Forms![stanmarfrm]![order number] & "-" & Forms![stanmarfrm]![order line] & " Required Qty" & " " & Forms![stanmarfrm]![req quantity] & " Regards Roly", True
 
DoCmd.SendObject , , , "mkingscote@stanmar.co.uk", , , "Forecast Required", "Please forecast part number " & Forms![stanmarfrm]![part number] & " " & Forms![stanmarfrm]![DESCRIPTION] & " on order " & Forms![stanmarfrm]![order number] & "-" & Forms![stanmarfrm]![order line] & " Required Qty" & " " & Forms![stanmarfrm]![req quantity] & vbCrLf & " Regards Roly", True
 
Thanks for that Mile-O-Phile works a treat.

Judo.
:)
 

Users who are viewing this thread

Back
Top Bottom