I have a Project table which has a related Team portal (which lists all the employees who are working on this project). I also have a related Notes portal (where you can input Notes for that project).

I want to be able to make a script that will send the Note contents to all the Team members that are related to that project. I can do a single email to one person, and the Send Multiple Emails script still sends just one email but for all found Projects.

Any ideas?

Thanks,

Brian

Are you really in FM6?

I can't tell bcs under your avatar it says FM6, but at the bottom of your post is says FM8.5.

I'll assume 8.5 and therefore script variables.

Write a script "Team Email" that:

1. Captures the Note (which one?) to $note

2. gtrr project to team

3. Loop thru each team record.

4. Send Mail script step using $note in the body part and a relationship from Team to People? to get the person't email address.

Hi Bcooney,

Based from OP's post,

This Post:

Client: 8.5 OS: Mac OS X Leopard Host: Server 7 OS: Mac OS X Leopard

I think the OP is currently working the project under version 8.5...

Edited:

I read somewhere else that a person can have default older version, but currently using a new version on a particular project.

Edited January 29, 200817 yr by Guest

Well, it doesn't take much to confuse me :)