Solved

Summary Email from SharePoint

Posted on 2015-02-20
11
491 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
11 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40620976
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 32

Expert Comment

by:Jamie McAllister MVP
ID: 40620979
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
ID: 40621008
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
Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40621028
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
ID: 40621039
workflow wouldn't work as it sends email on every item and not as a summary.

Any suggestion on building a code?
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40621129
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
ID: 40621652
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
ID: 40625270
Any suggestion in using Powershell script with SharePoint client side object model
0
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40625294
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
ID: 40625550
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
ID: 40641294
I found the solution myself and have posted the details in comments
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

737 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