emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Event set up to automatically send an email when a form is closed.
In that email I list the information that is in several of the fields. How
can I make it put that information on separate lines in the email: example

1 2 3 4 to look like:

1
2
3
4

Thanks in advance for any help
 
Guessing that you would add new line between the fields in a calculation and
send that.

Field1 & chr(13) & Chr(10) & Field2 & chr(13) & Chr(10) & Field3 & chr(13) &
Chr(10) & Field4
 
I'm not getting it to work.

here is what I have now. I would like to show each of these field on a
different line in the email. Note the section of astricks is actually email
addresses, I masked those

rDoCmd.SendObject acSendNoObject, , , Me![Team Leader].Column(2), *******",
, _
"QI Notification", "QI # =" & Me![QI #] & "Lot Disposition" & Me![Lot
Disposition] &" Rejection Type= " & Me![Rejection Type] & "
O#=" & Me![MO#] & " Part #=" & Me![Part #] & " Customer/Vendor=" &
Me![Customer].Column(1) & " Shade=" & Me![Shade] & " Batch Code=" &
Me![Batch Code] & " Reject Qty" & Me![Reject Qty] & Me![Units] & " Reject
Reason = " & Me![Rejection Reason], , False

thanks again
 
Nevermind. I discovered my problem.

Thank you John.
--
aj


AJ said:
I'm not getting it to work.

here is what I have now. I would like to show each of these field on a
different line in the email. Note the section of astricks is actually email
addresses, I masked those

rDoCmd.SendObject acSendNoObject, , , Me![Team Leader].Column(2), *******",
, _
"QI Notification", "QI # =" & Me![QI #] & "Lot Disposition" & Me![Lot
Disposition] &" Rejection Type= " & Me![Rejection Type] & "
O#=" & Me![MO#] & " Part #=" & Me![Part #] & " Customer/Vendor=" &
Me![Customer].Column(1) & " Shade=" & Me![Shade] & " Batch Code=" &
Me![Batch Code] & " Reject Qty" & Me![Reject Qty] & Me![Units] & " Reject
Reason = " & Me![Rejection Reason], , False

thanks again
--
aj


John Spencer said:
Guessing that you would add new line between the fields in a calculation and
send that.

Field1 & chr(13) & Chr(10) & Field2 & chr(13) & Chr(10) & Field3 & chr(13) &
Chr(10) & Field4
Click to expand...
Click to expand...
 
Back
Top