Is there any way to get an excel export from a SharePoint list and email to users in SharePoint 2010?
We have a list which update weekly and I want to email all users in format of Excel
-
Do you want to do this by a workflow?– Md. Tahmidul AbedinCommented May 3, 2016 at 7:15
Add a comment
|
1 Answer
Default Functionality of export to excel for list is Awesome, but according to me the same cannot be call through any API. So I would suggest rather than Workflow, go with SharePoint Timer Job feature.
This link would help you do the same and achieve your functionality
http://bhatiaashish.blogspot.in/2012/09/export-to-excel-and-email-sharepoint.html
https://msdn.microsoft.com/en-us/library/cc427068(v=office.12).aspx
You can also achieve the same functionality using PowerShell code to export the list to Excel file and then send email to the mail adress, and use the Windows Task Scheduler to trigger the above PowerShell code daily/weekly/monthly, please see more from posts below.
http://get-spscripts.com/2011/01/running-sharepoint-powershell-script.html
-
thank you I want to use the code of bhatiaashish.blogspot.in/2012/09/… but how can i activate it on my web application is there any manual ? Commented May 7, 2016 at 5:06
-
because as I know we need wsp file to deploy but there is not any .wsp file Commented May 7, 2016 at 5:42
-
Bhatia Ashish blog will help you achieve thefunctionality you need. And neccessary steps needed to deploy and activate timer job can be found here. sharepointpals.com/post/… codeproject.com/Tips/634208/… Commented May 9, 2016 at 5:08
-
thank you your first link contain a source code how can I use that bhatiaashish.blogspot.in/2012/09/… there is a solution and I donnot know how to use that best regards Commented May 9, 2016 at 5:27