Add a Report to a Sharepoint Document Library
Overview
Sharepoint is widely used by many organizations to act as a central repository for documents that are shared across users. It is possible to have reports be scheduled to run and automatically be emailed and uploaded into a particular document library on the Sharepoint server. This article covers the steps necessary to create a scheduled task in the Jet Excel add-in to email a report to the document library
Configuring the Document Library in Sharepoint
The process of configuring Sharepoint for specific needs is outside of the scope of our expertise at insightsoftware. Please contact your Sharepoint administrator for any issues encountered in this section.
In order to email reports to a Document Library in Sharepoint, it is first necessary to ensure that the Document Library has been configured to receive incoming emails.
Microsoft has provided documentation on how to configure the Document Library properly and this documentation can be accessed through the following link:
Enable and Configure E-Mail Settings for a Document Library
Creating a Scheduled Task in the Jet Excel add-in to Email a Report to the Document Library
A detailed Knowledge Base article on scheduling reports to run automatically can be accessed through the following link:
On the Email tab, the checkbox should be selected to have the report emailed. The email address to be used should correspond with the email address that has been configured for the Document Library in Sharepoint (eg: SalesDocuments@mysharepointserver.com).
Once the task has been scheduled the report will run, email to the Document Library, and the report will then be visible in Sharepoint.