[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 909
  • Last Modified:

Summary Email from SharePoint

I have designed a list on SharePoint and need to send a summary email automatically like it happens when you design a workflow.

I know its now possible via SharePoint designer, as its send emails for each item created.

Any help would be appreciated.
0
brkenigma
Asked:
brkenigma
  • 6
  • 3
  • 2
1 Solution
 
Rainer JeschorCommented:
Hi,
what kind of summary email do you want to get?
Which SharePoint version and edition?
If you want to get a daily summary of added/changed/deleted items, you might simply add an alert on that list for yourself (or if you have permissions also for other users).
HTH
Rainer
0
 
Jamie McAllister MVPArchitectCommented:
Alerts can be used to send activity summaries, and can be very selective indeed.

There's an article about that here;

http://the-north.com/sharepoint/post/User-Alerts-and-Views-to-Send-Selective-Emails
0
 
brkenigmaAuthor Commented:
the alert option does not meet the requirement.

i have a list created with several items in it and each of these have a status. I need to send a summary based on the different status.

The summary reports, tell me about the add/deletes/any edits made
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Jamie McAllister MVPArchitectCommented:
If you don't create a workflow or code something, the only other thing aside from Alerts to have that information is Audit. It is possible to email that out, but it is not in a friendly format at all.
0
 
brkenigmaAuthor Commented:
workflow wouldn't work as it sends email on every item and not as a summary.

Any suggestion on building a code?
0
 
Rainer JeschorCommented:
Hi,
it depends a little bit on your exact requirements, but I would go a route to use Powershell script with SharePoint client side object model to query the list, generate a nicely formatted HTML email and run the script on your requirements (manuall, scheduled once/twice a day ...).
But it depends also on your SharePoint version (and edition)?
Thanks and HTH
Rainer
0
 
brkenigmaAuthor Commented:
I am using the 2010 version of share point, like an automated email is sent when the workflow is initiated. Similarly at the end of each day i want to send a summary report summarize by the status for all the items in the list.
0
 
brkenigmaAuthor Commented:
Any suggestion in using Powershell script with SharePoint client side object model
0
 
Jamie McAllister MVPArchitectCommented:
This article shows how to retrieve items from a list using Powershell and CSOM;

https://soerennielsen.wordpress.com/2013/08/25/use-csom-from-powershell/
0
 
brkenigmaAuthor Commented:
i think i found a solution, created another list to summarize the data from the master list using infopath and then played a little with the add, update and delete workflows to have one active record on the summary list and send the email.

Used below link to design form on infopath.
http://blogs.sharepoint911.com/blogs/jennifer/Lists/Posts/Post.aspx?ID=70
0
 
brkenigmaAuthor Commented:
I found the solution myself and have posted the details in comments
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now