Send daily email with multiple News Items

Question

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:

1. A Document Library with a number of columns: News Title, News Date, Attachment (PDF Format)

2. The Department uploads each News items on the Document Library.

3. 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?

Answer 1

1. Consider SharePoint's alerts, as @Christoffer proposed in comments

2. Native way of delivering news is RSS - and desktop Outlook supports it, as well as dozen of programs do. RSS is also useful to integrate news into other websites (SP and non-SP)

3. If you prefer a workflow for this, use site workflow. You'll need to figure out how to launch it once a day - check this.

Also, I'd use usual custom list for this, not a document library.