Solved

How to email sharepoint list items as a excel spreadsheet attachment

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

735 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