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/
