Reports subscription

Hello to everyone!

I have a question. I need to create subscriptions for set of reports. I have a task to send it via e-mail but I need to be able to send not to e-mail but for user name from Global Address List or for whole groups. When I just type user name from that list I got an error that invalid e-mail. Is it possible to do it or I need to use e-mail?

Thanks,

You would need to use e-mail to send to email addresses. SQL RS can't talk to Outlook.

You could probably write a custom wrapper to convert user names / distribution lists to email addresses, and append to the subscription.

Alternatively you should be able to setup the subscriptions using a command line or script.

http://www.sqldbatips.com/showarticle.asp?ID=62 - Try RS Scripter to see examples of subscription scripts.

hope this helps!

Andrew