Applescript to mail merge, with attachments
- or -
Post a project like this3842
£100(approx. $124)
- Posted:
- Proposals: 1
- Remote
- #324719
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 2 hours
Using a Mac, I have a situation where I have a situation where I must send emails to 242 recipients, all containing the same boilerplate subject and body text, but each requiring its own unique attachment (and in the case of five of those recipients, two or more attachments)
To do the first part, I've found a mailmerge script whereby i create a list of recipients line by line in a text file, in the format:
Recipient Name - email address (email in chevrons)
And in a separate text file I create the boilerplate body text.
You then run the script, select the relevant text files, and are then prompted to enter the subject, and email account to use, and the script creates and saves drafts of the emails.
However there is no method here of attaching the PDF attachments, which is where I seek your help.
I would imagine that scripting this to add the same attachment to each email would be reasonably straightforward. However, each recipient requires their own attachment.
Fortunately, the filenames of my attachments already begins with the same Recipient Name as used in the text file, so i'm sure this would help make attaching the correct PDF to the correct email somewhat easier.
The applescript i'm already using may be found at: http://boldlyopen.com/2008/08/26/poor-mans-mail-merge-in-apple-mail
With the bulk of the mailmerge done, I imagine it should be reasonably quick to create the logic to add the correct attachments.
Thanks in advance,
Jamie
To do the first part, I've found a mailmerge script whereby i create a list of recipients line by line in a text file, in the format:
Recipient Name - email address (email in chevrons)
And in a separate text file I create the boilerplate body text.
You then run the script, select the relevant text files, and are then prompted to enter the subject, and email account to use, and the script creates and saves drafts of the emails.
However there is no method here of attaching the PDF attachments, which is where I seek your help.
I would imagine that scripting this to add the same attachment to each email would be reasonably straightforward. However, each recipient requires their own attachment.
Fortunately, the filenames of my attachments already begins with the same Recipient Name as used in the text file, so i'm sure this would help make attaching the correct PDF to the correct email somewhat easier.
The applescript i'm already using may be found at: http://boldlyopen.com/2008/08/26/poor-mans-mail-merge-in-apple-mail
With the bulk of the mailmerge done, I imagine it should be reasonably quick to create the logic to add the correct attachments.
Thanks in advance,
Jamie
Jamie L.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
14 Oct 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies