We have a requirement to have automation of sending emails with Attachments. For example the ff. scenario:
- User requests for a document which user does not have access.
- Then some approvals happen and once approved
- Once approved, workflow will send the document as an attachment to the user
I don't think out of the box SharePoint Designer workflow can do this.
My current thinking is we can use Custom Visual Studio workflow to download the document and then send an email as attachments using custom code. However, I am concerned with large files or large number of files. Is there a memory limitation or it might slow down the performance of our server if the workflow email attachment constantly runs?
Or are there any better approaches to this one?