Solved

Summary Email from SharePoint

Posted on 2015-02-20
11
322 Views
Last Modified: 2015-03-03
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
Comment
Question by:brkenigma
  • 6
  • 3
  • 2
11 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
Comment Utility
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
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
Comment Utility
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
 

Author Comment

by:brkenigma
Comment Utility
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
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
Comment Utility
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
 

Author Comment

by:brkenigma
Comment Utility
workflow wouldn't work as it sends email on every item and not as a summary.

Any suggestion on building a code?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 44

Expert Comment

by:Rainer Jeschor
Comment Utility
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
 

Author Comment

by:brkenigma
Comment Utility
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
 

Author Comment

by:brkenigma
Comment Utility
Any suggestion in using Powershell script with SharePoint client side object model
0
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
Comment Utility
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
 

Accepted Solution

by:
brkenigma earned 0 total points
Comment Utility
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
 

Author Closing Comment

by:brkenigma
Comment Utility
I found the solution myself and have posted the details in comments
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now