Solved

How to email sharepoint list items as a excel spreadsheet attachment

Posted on 2014-09-15
2
1,663 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DateTimepicker 4 33
Connection String 16 43
Get Client IP on RDS - VB.NET 15 30
converting visio 2010 to powerpoint 2010  - formatting issues 5 41
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

863 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

23 Experts available now in Live!

Get 1:1 Help Now