create e-mail from multiple record contents

M

MM

I would like to pass multiple PIN's (waybill#'s) out to trace (via e-mail)
based on a relationship of the lead PIN (where Shipment/Piece = "S") to
Reference I'd like the code to work from an access form into which the PIN
Reference is entered. Sample of PSS_Details table contents below.

PSS_Detals | Shipment/Piece | PIN | Reference | Pieces | Shipment Code |
Customer Code
S | YYZ80334243112 | 114588 | 7 | MANUAL | RZ90031
P | YYZ80334243120 | 114588 | 7 | MANUAL | RZ90031
P | YYZ80334243138 | 114588 | 7 | MANUAL | RZ90031
P | YYZ80334243146 | 114588 | 7 | MANUAL | RZ90031
P | YYZ80334243153 | 114588 | 7 | MANUAL | RZ90031
P | YYZ80334243161 | 114588 | 7 | MANUAL | RZ90031
P | YYZ80334243179 | 114588 | 7 | MANUAL | RZ90031

The tracing e-mail needs to have each PIN on a single line. I would like the
create an complete e-mail send or at least return the PIN numbers each on a
separate line to copy and paste.

Thanks for your consideration,

MM
 
Top