View Single Post
  #2  
Old 05-14-2009, 12:11 AM
bluesky bluesky is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 667
bluesky is on a distinguished road
Default Re: Automate Report -> Excel -> OutLook

Hi,

Reporting Services provides an e-mail delivery extension that allows users to subscribe to reports that are subsequently delivered to electronic mailboxes. The Report Server E-mail delivery extension must be configured before you can use it. Configuring a report server for e-mail delivery requires the following:

A Simple Mail Transfer Protocol (SMTP) server or gateway. An account that has permission to send e-mail from the SMTP server. Depending on security policies in your organization, you might need to request permission in advance to send e-mail from a corporate SMTP server. Check with your system or network administrator for more information. The Report Server service must have Send As permissions on the SMTP server.

To configure report server e-mail, you can use the Reporting Services Configuration tool or you can edit the configuration files. The Reporting Services Configuration tool provides the minimal settings that the report server requires. If you want to use a local SMTP service or specify advanced settings, modify the configuration files instead.

The Outlook is a client application to view an email.

A subscription job uses the SQL Agent Service to run in schedule. So, you should need to startup the SQL Server Agent service before subscribing a report.

For more information, please see:

How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration):

How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration)



If you have any more questions, please feel free to ask.
Reply With Quote