isv_2004
Registered User.
- Local time
- Today, 06:26
- Joined
- Oct 19, 2004
- Messages
- 14
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
________________________
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
________________________