eMail Function: Sending multiple records

[lizzie]

Greetings

I have recently added a little function to our order system whereby our stock controller can send an email to a sales consultant alerting them that their stock has arrived.

The email contains the PO number, date arrived, client name, product description and quantity. The problem is that there can be more than one item on an order but when the email is sent, only the first item is included in the email. . . (obviously the fields for product, desciption etc are housed in a DB)...

Does anyone know how I can get around this so that all items received can be included in the email sent?

Any help will be mostly appreciated!

[mr_vodka]

If you create a calc field in your Order line items table which concatenates the fields that you want in the format that you desire, such as:

cOrderInfo =

PO number & " " & date arrived & " " & client name & " " & product description & " " & quantity

Then from your orders table, you can use the List (cOrderInfo) in a calc to display all the items for that order and use this calc for your email.

[IdealData]

Consider producing a report in preview mode and then use:

Save Records As [PDF]

then you can start your email with the PDF as your attachment.