Burke

Looping it will be. Thanks for your help.

I got the looping script to work (thanks Dana) but I wonder if there is a way to get the data directly from the Portal? Thanks for the help.

I have two databases: departments and people. Each department has a unique number. Each person has a the number of his/her department. The department number is the basis of the relationship between tables. I want to send an email to each department head with the information about the department and the list of people in that department. The people in each department are displayed in the department layout in a portal. Inserting the department information in the message portion of the email is no problem. The question is: How do you list the data from the portal in the email message?

I have a container field which can display a reference to a Word document--right click, Insert File. I would like to click a button (run a script) which would launch Word and load the document. I've tried the Send Event function but it will either launch Word without loading the document, or do nothing. I can't figure it out. Thanks in advance.