send email through sql server 2005 reporting service

  • hi,

    actually as per our requirement we need to send report output into mail.... so it's runtime we need to send mail of report .... anybody know how to do that through reporting service .. any response or ideas are welcome

    Raj Acharya

  • Hello Raj,

    You can save the report to shared folder. After that with Database mail send the report as an attachment.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • hi can u tell me steps for that i m till now know that to just genrate report and but can we do that like automatically save that into one folder and then in input parameter we enter email address and that will send ...like that if you have idea to do that .... so please tell me with some brief description or if you have time then step by step...

    Raj Acharya

  • please if any one know how to sent the sql server 2005 report through mail automatically on specific time .

  • Hey you can send your report through mail using data driven subscription and also you can schedule it.

    Raj Acharya

  • data driven subscriptions are only available in Enterprise edition so not everyone might have the right version to do that, but you can still use the normal subscription method to send to email or fileshare which ever is your preference

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply