I have the below business case/scenario for implementation on SharePoint.
Daily News items are issued by the Department. Currently, the Department attaches the news items to the email at the end of business day and send it. This is causing issues and flooding mailboxes.
I would like to implement the below:
A Document Library with a number of columns: News Title, News Date, Attachment (PDF Format)
The Department uploads each News items on the Document Library.
A workflow runs every day (at a specific time) and sends an automatic email to all users with the Title of each News Item. The Title should be linked to the PDF of the actual news item. The email should encompass only the News Items that were uploaded on that day. E.g. the email should not include news items from other days.
This way, the Department users only need to upload the news item on the document library. SharePoint and the workflow will do the rest of the work.
Is this possible? And if so, can you advice on the method to be used?