On May 26, 2010, at 11:06 PM, Andy Gordon wrote:

> We need to send multiple emails to clients with multiple attachments. We want to use their names in the greeting in the message, i.e Dear Bill,
> 
> We have been able to send one email with one attachment but no client name in the greeting or multiple attachment.
> 
> Is this possible?

Yes, with some caveat.

First, FileMaker Pro's function to send email is limited to a single attachment. To send multiple attachments you will need to use an email plug-in. I would suggest the excellent plug-ins on offer from CNS or 360Works among others. We created a bolt-on email sending system using a plug-in to accomplish just that.

Second, as far as sending with a client greeting, you need to use a calculation for your message body. For example:

"Dear " & Client::name & ",¶¶" & 
"Thank you so much for your contribution of $" & Amount & " on " & giftDate & ". Because of your generosity we will be able to ..."

Our email sending solution uses a custom function to replicate using merge fields on a layout. This makes it a bit more familiar for users without having to teach them FMP calculation syntax. The above would look like

Dear <<Client::name>>,

Thank you so much for your contribution of $<<giving::Amount>> on <<giving::giftDate>>. Because of your generosity we will be able to ...


In both cases the calculation expression is evaluated to read as:

Dear Andy,

Thank you so much for your contribution of $150 on 5/27/2010. Because of your generosity we will be able to ...


I'd encourage you to download demos of some of the plug-ins and try the example files that come with them. I think you'll see that the functionality you're looking for is fairly straightforward to implement.

Cheers,
-corn


Cornelius Walker
The Proof Group
http://proofgroup.com/