Automatic Attachment in Send Mail Script

[HHMacGuffin]

Hi,

My database has a Send Mail script that creates an email for each contact. The Subject and Message are filled in automatically based on their respective global fields, which are editable by the users of my database.

However this option is not available for attachments. My original idea is to have a global Container field where my users can insert a file, and then use the script to send out large number of emails with the inseted file as an attachment. Is there anyway I can make Filemaker create emails that also attaches whatever file my users chose automatically?

The rationale behind this is that the users of my database have almost no training in Filemaker, and we often have to send emails (with attachments) to hundreds of people in one go rapidly.

Any suggestions are much appreciated, thanks!

MacGuffin

[bcooney]

FM's built in email functionality supports only one attachment per email. If you require more than one attachment or need formatting or graphics, then you'll need a plugin.

It is also not wise to send hundreds of emails because you might get flagged as a spammer. You might want to use ConstantContact or MailChimp.

However, attaching a file to an email is fairly straightforward. Assume you've inserted a file into a container:

Set Variable [$Path ; Get ( TemporaryPath ) & "FileName.PDF" ]

Export Field Contents [YourTable::ContainerField ; $Path ]

Send Mail [send via email client; To: Emailaddfield ; Subject: "Requested File" ; Message: "Message text" ; "$Path"]