DoCmd.SendObject to Email syntax

[isv_2004]

I need help with DoCmd.SendObject to Email, I cannot get a carrige return in the body of the form, HELP please!

DoCmd.SendObject acSendForm, "Current_ICS", acFormatXLS, MyValue, , , "Shipping form for ICS# [ " & ICS_NO & " ] ", "1 " & "2 " & "3 " & "4 ", -1

The Email form looks like this:
________________________
|
| TO: ME@someplace.com
| Subject: Shipping form for ICS# [ 607883 ]
|
| 1 2 3 4
|
| attachment Current_ICS.xls
________________________

What I want is this:
________________________
|
| TO: ME@someplace.com
| Subject: Shipping form for ICS# [ 607883 ]
|
| 1
| 2
| 3
| 4
|
| attachment Current_ICS.xls
________________________

 

[MarkK]

"1" & vbCrLf & "2" & vbCrLf & "3" & ...

 

[isv_2004]

Lagbolt,

Thank you!

It worked great.