Send Email to multiple addresses

[jimlongo]

Hi, I'm looking for some help here. I've read posts and knowledge Base topics and the Help Guides and i'm stumped.

I have a script in FMP9 that produces a PDF and emails it. I want to send it to multiple recipients.

My Send Mail Options are Create One email using data from the current record.

It says clearly (to me anyway) that I should be able to put multiple email addresses in the TO line of the "Send Mail" Options - separated by a semicolon or carriage return. But whenever I try to do that I get the error message "An operator (eg. + - . . . ) is expected here" and cannot add another email.

Today I am at work on OS X 10.4.11

Any help would be greatly appreciated.

TIA, jim

[jimlongo]

On further investigation the semi-colon is used to separate email addresses that have been typed in.

But I am using email addresses collected from the found records using the pop-up in the Send Mail options.

Specify Field Name . . .

There doesn't seem to be the ability to add multiple fields using this method. At least not that I can see.

The other option is to use a calculation. I've tried various operators and text functions, but none of them gives a satisfactory result.

Any other ideas?

Thanks,

jim

[jimlongo]

In case anyone else is trying this, I finally hammered out a solution.

In the Send Mail options

Specify Calculation . . .

the calculation that worked for me is Field1 &¶& Field2

I guess it might help you to look at Text Operators in the help manual.

Hope this helps,

jim

[sdcagle]

Thanks, this is exactly what I was looking to do.

Scott

[jimlongo]

Just a note that if you use this in Mac OS X Leopard Mail.app the carriage return will cause a non-fatal error message (something about an empty address) when you send the email.

What works better in that case is a comma in the calculation instead of a carriage return or semicolon.

Field1 &","& Field2