Solved

How to email sharepoint list items as a excel spreadsheet attachment

Posted on 2014-09-15
2
1,765 Views
Last Modified: 2014-10-08
I have sharepoint 2007 list where user will create list items. He wants all the list items to be e-mailed weekly once as a excel spreadsheet. How can I acheive this?

Any example would be great
0
Comment
Question by:bujjigadu
2 Comments
 
LVL 12

Assisted Solution

by:Ramkisan Jagtap
Ramkisan Jagtap earned 250 total points
ID: 40324619
You can write a custom SharePoint job which will export the list to excel and send it across every week.

Check following links for creating a SharePoint Job:
http://www.splessons.com/2013/12/create-a-timer-job-in-sharepoint-2013/
http://blogs.msdn.com/b/guruketepalli/archive/2012/01/23/sharepoint-2010-custom-timer-job-send-an-email.aspx
0
 
LVL 31

Accepted Solution

by:
Jamie McAllister MVP earned 250 total points
ID: 40324770
Please don't write a custom Timer job, and this is why;

http://www.the-north.com/sharepoint/post/Dont-write-SharePoint-Timer-jobs-(etc)-without-good-reason

http://the-north.com/sharepoint/post/Alternatives-to-SharePoint-Timer-Jobs

Consider hosting the process away from your SharePoint install if at all possible. For SharePoint 2007 I'd suggest a simple C# console app (in 2010 and above I'd have gone for Powershell) calling into the web services to get your list data, and adapting that data into an excel format (CSV or XML would be simple enough), then emailing it.

The scheduling I'd do through Task Scheduler in Windows. It's simple and robust, and the config can be exported and imported, so it's easy to port between dev, test and prod environments.

Much less plumbing code needed than a timer job, less risky to your install.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 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