I am trying to set up a script to send an email to a field specified recipient[Email Address].

I have done this thus far, however there is ONLY an option to either send:

One email using data from the current record

Multiple emails (one for each record in found set)

I want to (if able) send One email, with a list of field values in the body of the email, possibly 2 field values [item Description] and [item ID].

eg. Say i do a Find for all records with a Due Date < Today, and there are 3 records found.

I want the Field Values [item Description] and [item ID] listed in the body of the email.

There would be 2 Field Values(Description & ID) for each record, thus six(6) field values placed into the email body.

How can i achieve this?

I do not want multiple emails sent, but one email with ALL the basic data from the Fields found.

Corey....

You can gather all the record data you want into a global field via a loop and then reference the global field as part of your body. Use tab and return spacing to make it neater. Something like:

Set [ gBody; "" ]

Go to record [first]

Loop

Set [gBody; gBody & ¶ & ItemID & " " & ItemDescription ]

Go to Record [Next; Exit After Last ]

End Loop

Send Mail []