Bulk Email with Individual Attachments

Started by TeaLeaf, January 16, 2014, 04:07:00 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

TeaLeaf

January 16, 2014, 04:07:00 PM
I have a looming problem with one of my clients where a previously hard copy system (that worked seamlessly) will have to move to an email-based system.   I will need to provide a the following each month to a varying number of different individuals:

-email (body text will be standard)
-some pdf attachments (which will be standard)
-a unique individual pdf attachment per recipient

I get the personalised pdf files from a third party.
I will provide the standard pdf and the email wording.
Yet another third party provides the recipient list.
And I want to do this through gmail.

Does anyone have any bright ideas as to how I would go about doing this?    I've never done any sort of email-merge before, so I'm at ground zero on it right now.
TL.
Wisdom doesn\'t necessarily come with age. Sometimes age just shows up all by itself.  (Tom Wilson)
Talent wins games, but teamwork and intelligence wins championships. (Michael Jordan)

BrotherTobious

#1
January 16, 2014, 04:13:00 PM
Had a quick look around but never tried it before this seems a ok ish way of doing it, if you using Google drive.

Here is the link
"It's hard, but not as hard as Arma!!!" Tutonic
"Over the centuries, mankind has tried many ways of combating the forces of evil... prayer, fasting, good works and so on. Up until Doom, no one seemed to have thought about the double-barrel shotgun. Eat leaden death, demon.." Terry Pratchett

TeaLeaf

#2
January 16, 2014, 04:13:45 PM
Quote from: BrotherTobious;380227Had a quick look around but never tried it before this seems a ok ish way of doing it, if you using Google drive.
I *don't* have a way of doing it, so not sure what you mean Toby!  I'm looking for some kind of automated process so that I will not need to create individual emails (it's not for spam purposes, it's a business need).
TL.
Wisdom doesn\'t necessarily come with age. Sometimes age just shows up all by itself.  (Tom Wilson)
Talent wins games, but teamwork and intelligence wins championships. (Michael Jordan)

BrotherTobious

#3
January 16, 2014, 04:15:19 PM
Quote from: TeaLeaf;380228I *don't* have a way of doing it, so not sure what you mean Toby!


Just you generic disclaimer of you try and it dont work dont shoot me : )
"It's hard, but not as hard as Arma!!!" Tutonic
"Over the centuries, mankind has tried many ways of combating the forces of evil... prayer, fasting, good works and so on. Up until Doom, no one seemed to have thought about the double-barrel shotgun. Eat leaden death, demon.." Terry Pratchett

TeaLeaf

#4
January 16, 2014, 04:18:39 PM
Ahah, a link added - thank you, I will take a look!
TL.
Wisdom doesn\'t necessarily come with age. Sometimes age just shows up all by itself.  (Tom Wilson)
Talent wins games, but teamwork and intelligence wins championships. (Michael Jordan)

TwoBad

#5
January 16, 2014, 04:23:37 PM Last Edit: January 16, 2014, 04:43:14 PM by TwoBad
I use Sendblaster and have never had a problem but i've not used it to send personalised attachments.

Take a look at this page : How to use programmable tags for multiple automatic email merge file attachments and scripts
The Battle of Damnation Alley, 25th January 2015
\'You are hereby awarded the Military Cross, posthumously, for an act of exemplary gallantry during active operations against the enemy on land.\'
[SIGPIC][/SIGPIC]

Gandalf

#6
January 17, 2014, 10:14:00 AM
Easy with MS Access and the Total Access Emailer plugin. http://www.fmsinc.com/MicrosoftAccess/Emails.asp

I've developed a customer service solution that emails personalised service reminders to customers with a personalised PDF voucher that they print out.

It does mean spending money to buy the software though! (Although if you have office pro, you'll have access already.)
*G*

Cake: Four large eggs. One cup semi-sweet chocolate chips. Three/four cups butter or margarine. One and two third cups granulated sugar. Two cups all purpose flour. Fish shaped ethyl benzene. Twelve medium geosynthetic membranes. Three tablespoons rhubarb, on fire.
Print
Go Up Pages1
User actions