I have a lecture tracking database & I'm trying to figure out if I can send an email that contains data that's displaying in a portal.

There are 5 lectures that occur each Thursday. I have a layout that displays the lecture date with a portal that displays the 5 lectures for that date.

I'd like to be able to generate an email that has the date, then lists the 5 lectures for that date. Is there any way to do this?

Each lecture also displays as an individual record in a different layout--I thought I could generate the email using that layout with a script that first finds the desired date (found set contains the 5 records for that date) but I can't figure out how to pull the 5 separate lecture titles into one email.

Hopefully I've provided enough info for someone to help--thanks!

__

UPDATE: I discovered the List function :

If I use List (Time), I get

7

8

9

10

11

but if I use List (Time; Speaker), I only get the 1st record

7

John Smith

Edited September 6, 200718 yr by Guest

Try defining a calculation field (in the source table) that concatenates all the required fields into a single line. Then use the List() function on that field.

Thanks!! That worked--is there a way I can sort the list function output so it's in order of hour (7,8,9...)?

The easy way would be to sort the relationship itself - the List() function will conform to that.