Need to compile records for email message

[JD Scott]

Hi,

I'm using the Send Mail script step and have made a calculation for the message of the email.

I'd like to email something like this:

Contact # 50777

---------------------

Information:

---------------------

Name: Scott Bobcat

Address: 72 Marietta Street NW

Phone: 322-526-5673

Email: [email protected]

My calculation looks like this:

"Contact #: " & " " & contact ID &

[transpower]

Loop over all the records of the found set.

[JD Scott]

thanks for the reply...

can I loop within a calculation? I'm not sure how to do that.

If I looped in the script (outside of the Send Mail script step) it would send individual emails for each record - not good.

[LiveOak]

You'll need to create a single email body part with all the information you want to display included. To do this you can create a global text field and loop through all the records in your found set concatenating each calculated field with your global field. This is subject to the maximum number of characters allowed in the global field (64K in FM6, 2G in FM7).

-bd

[JD Scott]

Thanks Brent,

I actually tried this before but failed to deselect "Select entire contents"

in the script. It just hit me.

Thanks

Jaime