I want to be able to create personlized emails for found sets. So for example if I run a search on 10000 contacts and come up with a group of say 2000 people how can I create an email that sends to all email addresses and insert the persons first and last name in the email when it sends.

Thanks!

Erik

First I'll say you probably want to do this with a e-mail newsletter provider, like MailChimp or Constant Contact. Sending 2,000 e-mails (solicited or not) is a quick way to get yourself blacklisted by ISPs, including your own. If for some crazy or really good reason, you're going to do this through FileMaker...

You'll want to create a couple global fields. One for "subject" and one for "body".

And you'll want a script with a Send Mail via SMTP step. I suppose you could send via client, but that's another nightmare.

That script will include a calculation for the body that includes your Body global along with whatever personalization you want.

We have had problems with FileMaker sending through SMTP to places like Hotmail and Gmail. They appearantly consider FMP emails to be spam and won't let them through or will dump them directly into the recipients "junk" folder. We had to stop using SMTP all together and have been reduced to sending through the client which of course is a real pain for sending multiple emails.