Sending Mail to Specific Contacts

[glenbeigh]

Hello! Please forgive a question from a novice, but I just can't find a way to do this...

I have a script with a Send Mail step. I want to address it To: any employees who are found by the following criteria: the "Position" field matches "Vice President" and the "Office" field matches an $$Office variable. For employees who match these criteria, I would like it to return the value from their "Email" field to the Send Mail script step.

I have some ideas how to accomplish this, but none that are even close to elegant. Thank you very much for any assistance.

[glenbeigh]

oh gosh, all i need to do is...

...

Go to Layout

Enter Find Mode

Set Field (for my two requirements)

Perform Find

Send Mail (and choose "collect address")

...

That's so simple. I was looking for some way to do it through the "Specify Calculation" box in the Send Mail options. Yikes.