emails

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AJ - 07 Dec 2005 03:03 GMT

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

Signature

Reply to this Message

John Spencer - 07 Dec 2005 13:52 GMT

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 have an Event set up to automatically send an email when a form is
>closed.
[quoted text clipped - 10 lines]
>
> Thanks in advance for any help

Reply to this Message

AJ - 08 Dec 2005 01:04 GMT

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

Signature

> Guessing that you would add new line between the fields in a calculation and
> send that.
[quoted text clipped - 16 lines]
> >
> > Thanks in advance for any help

Reply to this Message

AJ - 08 Dec 2005 01:22 GMT

Nevermind. I discovered my problem.

Thank you John.

Signature

> I'm not getting it to work.
>
[quoted text clipped - 33 lines]
> > >
> > > Thanks in advance for any help

Reply to this Message