Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drpcken
Starting Member
20 Posts |
 Posted - 2004-12-30 : 15:42:08
|
| Here's what I'm looking for... I need the feature that when a report is generated, it automatically sends a copy of the report to a certain email address I specifiy before hand. This address won't change and will not need to be provided when the report is generated. In fact the user doesn't even need to know the email is being sent, should be all behind the scenes.I know I could use the subscription option, and I've suggested that, but the boss wants it the way described above. Thanks! |
|
|
jhermiz
3564 Posts |
Posted - 2004-12-30 : 18:06:15
|
quote:
Originally posted by drpcken
Here's what I'm looking for... I need the feature that when a report is generated, it automatically sends a copy of the report to a certain email address I specifiy before hand. This address won't change and will not need to be provided when the report is generated. In fact the user doesn't even need to know the email is being sent, should be all behind the scenes.I know I could use the subscription option, and I've suggested that, but the boss wants it the way described above. Thanks!
Umm..That is EXACTLY what a subscription does!Tell your boss to suck on some wisconsin cheese and deal with it .Use reporting services subscriptions...otherwise you'll have to write unnecessary code...If you do have to end up writing code, simply build an smtp application using vb.net or C#. Run the report and export it to the format they like , and attach it to the email using the smtp mail object or the outlook exchange object model.JonA new beat on the web -- http://www.web-impulse.com |
 |
|
|
|
|
|
AutoEmail on Generate