?
Solved

Summary Email from SharePoint

Posted on 2015-02-20
11
Medium Priority
?
698 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

765 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