Using WordFly or Mail2 (or Outlook?) for Contribution Acknowledgments?

Hello all,

Does anyone use an email marketing service like Mail2 or WordFly to send out emails thanking donors/members?

We currently post out a whole bunch of paper acknowledgements for all contributions, and I am sure there must be a better way.

I have experimented with doing a mail-merge into Outlook, but haven't found the end result to be very elegant considering the variety of different contributions (new/renewed/assigned memberships etc...).

I would love to hear about any out of the box solutions, or clever ideas to massage pretty acknowledgements into Outlook.

Best,

Nicholas

Parents Reply Children
  • Thanks for sharing your processes Tamiko, sounds very cool :)

    For household memberships, do you have email addresses on the household? Or does your nifty custom report pull the email for WordFly from the individuals within the household?

  • We aren't using Wordfly for acknowledgements (yet!) - but we implemented a nifty pre/post-show triggered email this year that does a complicated mix of grabbing emails attached to orders, and if they don't exist, it grabs all the primary emails on/affiliated to the purchasing account. (I'll have our system documented in the 2013 TLCC Mini-Magic...hopefully...!)

    Essentially a local procedure runs each night to fill a local table with the necessary fields for Wordfly, then an output set feeds that info to Wordfly. Our procedure does the heavy lifting of determining the email addresses - and for some, there are two addresses that get the "same" email (if both spouses have primary emails). Like Nicholas, we tend to keep emails on the individual, and data on the household.

    Happy to pass on more details if you like...

    Beth

  • Wow Beth, you said the three magic words: Primary Email (on) Affiliated!

    I would love to see some more details if you are happy to share, much appreciated.

  • I have hit a stumbling block when trying to display the creditor/creditee (for gift memberships) in my output set. The value I need is present in the file saved from the 'Print Acknowledgments' utility under the 'd_esal1_desc' column, but is not present in the 'T_ACK_EXT' table.

    Has anyone else encountered this particular challenge?

    Fetching this value would allow the WordFly emails to have messages like:

     

    • Dear River Tam, thank you for purchasing a gift membership for Malcolm Reynolds!

     

    and

    • Dear Malcolm Reynolds, River Tam has purchased a gift membership for you.

     

    where Malcolm Reynolds is the creditee and River Tam is the creditor.

     



    [edited by: Nicholas Hudson-Ellis at 1:01 AM (GMT -6) on 11 Sep 2013] Line spacing improvement