[OT] need info on sending FileMaker SMTP mass emails with different email body for each email to

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[OT] need info on sending FileMaker SMTP mass emails with different email body for each email to

Tami Williams-3
I'm trying to get as much info as possible on the best way to send out < 500 emails a day where

1. the list of email addresses comes from FileMaker 13 and can change daily
2. each email (the email body content) is different

So if I have 150 emails to send out today there will be 150 different emails - the content of each is totally unique - much much more than a simple "mail merge"; the content = a list of related items for each person coming from a related FM table.


Questions:

- what are the potential issues using FileMaker 13 SMTP

- what are the ways around these issues

- have you done this, or can you connect me with someone who has

- I've looked at ways to work with MailChimp, Constant Contact, and Mandrill but none seem to allow the dynamic creation of the email body so that I can have 150 unique emails for 150 email to address; is there a way to do this that I don't know about?

- does the best way to handle this change if the number of emails / day is < 200 vs. < 500 ?  how about over 500/day?


Thanks in advance.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It's better to burn out than to fade away."

Tami Williams
Creative Computing
Let us help you make frustrating, costly, and inefficient processes more efficient, less costly and scalable.
Lasso, MySQL and FileMaker specialists.

Tel/Fax: 770.457.3221
E-Mail: [hidden email]
Web: http://www.asktami.com/
LinkedIn: http://www.linkedin.com/in/asktami
Twitter: http://twitter.com/asktami
iChat/AIM/Skype: tamiwilliamsusa

FileMaker Business Alliance Member | Lasso Professional Alliance Member | Certified Lasso Developer | FileMaker 11, 12 & 13 Certified Developer

------

If you want to receive sporadic email from Creative Computing regarding news at the company and announcements about upcoming Lasso webinars and online classes, please opt-in at http://tinyurl.com/yj7eqlg


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: [OT] need info on sending FileMaker SMTP mass emails with different email body for each email to

stevepiercy
Mandrill (and pretty much any other transactional mail provider)
supports what you describe.

You can use merge tags in your template.
http://help.mandrill.com/entries/21678522-How-do-I-use-merge-tags-to-add-dynamic-content-

You can even use conditional logic with merge tags.
http://help.mandrill.com/entries/28427818-Can-I-use-dynamic-or-conditional-merge-tags-

MailChimp and Constant Contact are intended for sending the same
email to a list of recipients.

--steve


On 10/23/14 at 9:26 PM, [hidden email] (Tami Williams) pronounced:

>I'm trying to get as much info as possible on the best way to
>send out < 500 emails a day where
>
>1. the list of email addresses comes from FileMaker 13 and can change daily
>2. each email (the email body content) is different
>
>So if I have 150 emails to send out today there will be 150
>different emails - the content of each is totally unique - much
>much more than a simple "mail merge"; the content = a list of
>related items for each person coming from a related FM table.
>
>
>Questions:
>
>- what are the potential issues using FileMaker 13 SMTP
>
>- what are the ways around these issues
>
>- have you done this, or can you connect me with someone who has
>
>- I've looked at ways to work with MailChimp, Constant Contact,
>and Mandrill but none seem to allow the dynamic creation of the
>email body so that I can have 150 unique emails for 150 email
>to address; is there a way to do this that I don't know about?
>
>- does the best way to handle this change if the number of
>emails / day is < 200 vs. < 500 ?  how about over 500/day?
>
>
>Thanks in advance.
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>"It's better to burn out than to fade away."
>
>Tami Williams
>Creative Computing
>Let us help you make frustrating, costly, and inefficient
>processes more efficient, less costly and scalable.
>Lasso, MySQL and FileMaker specialists.
>
>Tel/Fax: 770.457.3221
>E-Mail: [hidden email]
>Web: http://www.asktami.com/
>LinkedIn: http://www.linkedin.com/in/asktami
>Twitter: http://twitter.com/asktami
>iChat/AIM/Skype: tamiwilliamsusa
>
>FileMaker Business Alliance Member | Lasso Professional
>Alliance Member | Certified Lasso Developer | FileMaker 11, 12
>& 13 Certified Developer
>
>------
>
>If you want to receive sporadic email from Creative Computing
>regarding news at the company and announcements about upcoming
>Lasso webinars and online classes, please opt-in at http://tinyurl.com/yj7eqlg
>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Soquel, CA
<[hidden email]>               <http://www.StevePiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: [OT] need info on sending FileMaker SMTP mass emails with different email body for each email to

minicooper
In reply to this post by Tami Williams-3
Hello Tami,

If you are sending the emails directly out of FMP you could look at Mailit (a Filemaker extension). Although I'm only sending out less than 100 emails a day with it, it has been pretty solid and is fully scriptable within Filemaker.

http://www.dacons.net/fmplugins/mailit6/

Roland Alston

On Oct 23, 2014, at 9:26 PM, Tami Williams <[hidden email]> wrote:

> I'm trying to get as much info as possible on the best way to send out < 500 emails a day where
>
> 1. the list of email addresses comes from FileMaker 13 and can change daily
> 2. each email (the email body content) is different
>
> So if I have 150 emails to send out today there will be 150 different emails - the content of each is totally unique - much much more than a simple "mail merge"; the content = a list of related items for each person coming from a related FM table.
>
>
> Questions:
>
> - what are the potential issues using FileMaker 13 SMTP
>
> - what are the ways around these issues
>
> - have you done this, or can you connect me with someone who has
>
> - I've looked at ways to work with MailChimp, Constant Contact, and Mandrill but none seem to allow the dynamic creation of the email body so that I can have 150 unique emails for 150 email to address; is there a way to do this that I don't know about?
>
> - does the best way to handle this change if the number of emails / day is < 200 vs. < 500 ?  how about over 500/day?
>
>
> Thanks in advance.
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "It's better to burn out than to fade away."
>
> Tami Williams
> Creative Computing
> Let us help you make frustrating, costly, and inefficient processes more efficient, less costly and scalable.
> Lasso, MySQL and FileMaker specialists.
>
> Tel/Fax: 770.457.3221
> E-Mail: [hidden email]
> Web: http://www.asktami.com/
> LinkedIn: http://www.linkedin.com/in/asktami
> Twitter: http://twitter.com/asktami
> iChat/AIM/Skype: tamiwilliamsusa
>
> FileMaker Business Alliance Member | Lasso Professional Alliance Member | Certified Lasso Developer | FileMaker 11, 12 & 13 Certified Developer
>
> ------
>
> If you want to receive sporadic email from Creative Computing regarding news at the company and announcements about upcoming Lasso webinars and online classes, please opt-in at http://tinyurl.com/yj7eqlg
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: [OT] need info on sending FileMaker SMTP mass emails with different email body for each email to

maxwellk2
In reply to this post by Tami Williams-3
I’ve set this up a couple of times using 360Works Email plugin and Mandrill, always works like a charm. Using Email’s EmailSetHeader...

        http://static.360works.com/plugins/EMAILPLUG/documentation.html#EmailSetHeader

...you can talk to Mandrill’s API via SMTP, setting merge tags as Steve points out ...

        http://help.mandrill.com/categories/20090941-SMTP-Integration
        http://help.mandrill.com/entries/21688056-Using-SMTP-Headers-to-customize-your-messages

My preferred method is to create a record for each email that contains all the necessary data, then run a scheduled script every 30 minutes under FileMaker Server that does the actual sending. Each record is flagged when successfully sent and stores the plugin’s sending result string, if any records error out they’ll get picked up the next time the script runs. I’ve seen the script send over 50 emails per minute.

I use the Email plugin for FileMaker in the client office and Jason Huck’s slick Mandrill tag for Lasso on their website, each able to access the same Mandrill account and use the same templates.

Thanks,
Max


> On Oct 23, 2014, at 6:26 PM, Tami Williams <[hidden email]> wrote:
>
> I'm trying to get as much info as possible on the best way to send out < 500 emails a day where
>
> 1. the list of email addresses comes from FileMaker 13 and can change daily
> 2. each email (the email body content) is different
>
> So if I have 150 emails to send out today there will be 150 different emails - the content of each is totally unique - much much more than a simple "mail merge"; the content = a list of related items for each person coming from a related FM table.
>
>
> Questions:
>
> - what are the potential issues using FileMaker 13 SMTP
>
> - what are the ways around these issues
>
> - have you done this, or can you connect me with someone who has
>
> - I've looked at ways to work with MailChimp, Constant Contact, and Mandrill but none seem to allow the dynamic creation of the email body so that I can have 150 unique emails for 150 email to address; is there a way to do this that I don't know about?
>
> - does the best way to handle this change if the number of emails / day is < 200 vs. < 500 ?  how about over 500/day?
>
>
> Thanks in advance.
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "It's better to burn out than to fade away."
>
> Tami Williams
> Creative Computing
> Let us help you make frustrating, costly, and inefficient processes more efficient, less costly and scalable.
> Lasso, MySQL and FileMaker specialists.
>
> Tel/Fax: 770.457.3221
> E-Mail: [hidden email]
> Web: http://www.asktami.com/
> LinkedIn: http://www.linkedin.com/in/asktami
> Twitter: http://twitter.com/asktami
> iChat/AIM/Skype: tamiwilliamsusa
>
> FileMaker Business Alliance Member | Lasso Professional Alliance Member | Certified Lasso Developer | FileMaker 11, 12 & 13 Certified Developer
>
> ------
>
> If you want to receive sporadic email from Creative Computing regarding news at the company and announcements about upcoming Lasso webinars and online classes, please opt-in at http://tinyurl.com/yj7eqlg
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: [OT] need info on sending FileMaker SMTP mass emails with different email body for each email to

Randy Zumwalde
In reply to this post by Tami Williams-3
Since most of our billing today is done via email vs. snail mail, I've
set up a method that emails invoices to our clients. We have the clients
email addresss and all of their invoice info in Filemaker. I set it up
so accounting can flag which invoices are due that will be emailed. Once
they are finished selecting the invoices that need to be emailed they
click a button that will open their web browser and run a web page in
Lasso. That web page finds the invoice records that need to be sent out
(25 max records with a page refresh every minute until all records are
processed), and includes a invoice.txt file that builds an html email
body of their invoice by grabbing the field data from FM. It also at the
same time builds a PDF of the invoice and attaches that to the email as
well.

Don't know if that helps but it has multiple email addresses and dynamic
email body content.

*Randy Zumwalde* . Tel: 513.651.1888
The John K. Howe Company, Inc.
7188 Main Street | Cincinnati, OH 45244

Be sure to visit us online at http://www.ehowe.com
Like us on Facebook at _https://www.facebook.com/howemarketing_
Looking for product ideas? visit _http://ehowe.mypromohq.com_

On 10/23/14, 9:26 PM, Tami Williams wrote:

> I'm trying to get as much info as possible on the best way to send out < 500 emails a day where
>
> 1. the list of email addresses comes from FileMaker 13 and can change daily
> 2. each email (the email body content) is different
>
> So if I have 150 emails to send out today there will be 150 different emails - the content of each is totally unique - much much more than a simple "mail merge"; the content = a list of related items for each person coming from a related FM table.
>
>
> Questions:
>
> - what are the potential issues using FileMaker 13 SMTP
>
> - what are the ways around these issues
>
> - have you done this, or can you connect me with someone who has
>
> - I've looked at ways to work with MailChimp, Constant Contact, and Mandrill but none seem to allow the dynamic creation of the email body so that I can have 150 unique emails for 150 email to address; is there a way to do this that I don't know about?
>
> - does the best way to handle this change if the number of emails / day is < 200 vs. < 500 ?  how about over 500/day?
>
>
> Thanks in advance.
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "It's better to burn out than to fade away."
>
> Tami Williams
> Creative Computing
> Let us help you make frustrating, costly, and inefficient processes more efficient, less costly and scalable.
> Lasso, MySQL and FileMaker specialists.
>
> Tel/Fax: 770.457.3221
> E-Mail: [hidden email]
> Web: http://www.asktami.com/
> LinkedIn: http://www.linkedin.com/in/asktami
> Twitter: http://twitter.com/asktami
> iChat/AIM/Skype: tamiwilliamsusa
>
> FileMaker Business Alliance Member | Lasso Professional Alliance Member | Certified Lasso Developer | FileMaker 11, 12 & 13 Certified Developer
>
> ------
>
> If you want to receive sporadic email from Creative Computing regarding news at the company and announcements about upcoming Lasso webinars and online classes, please opt-in at http://tinyurl.com/yj7eqlg
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>    the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>