We have a vendor who is not on our network and cannot access our 2010 SharePoint sites. I have a document library for that vendor with a subscription so that Reporting Services creates a report for that vendor and sends it to his document library. How can I use a workflow to send the report as an attachment to his email? (In the Field Data to Retrieve dialog, I can't find the document itself in the Field From Source dropdown. )
This cannot be done out of the box. But there is a solution on Codeplex that adds a custom workflow activity. This activity allows you to attach files that are either attachments in a list or documents in a library.