Solved

How to email sharepoint list items as a excel spreadsheet attachment

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

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

Title # Comments Views Activity
Error import assembly 19 27
Load XML element 3 43
Which is best Image Resizing Web service 11 41
ASP.NET VB code for check and insert in a table 4 45
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 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