For my day job, I regularly need to send a daily dashboard report (I call these "Daily Awareness Reports") as an attachment to emails.
Having generated a pdf of the report I use Hazel and AppleScript to attach the pdf to an email and send it. Furthermore, I send myself an email with the report to check that it has been completed correctly and maintain it for my records.
I previously tried an Automator workflow, but the "Get Selected Finder Items" command would include previously selected files and attach them to the email as well. Needless to say, this could look a little unprofessional....
So here is my workflow.
I created a Dropbox folder for Daily Awareness Reports, which is where I save these reports when they are completed.
Next, I get Hazel to watch this folder.