Is is possible to change the sender when using XP_Sendmail? I am sending a
notification that reports are available in reporting services in a single
email and want to change the sender from SQLSERVICEADMIN to something users
will recgonize easily.
Thanks for the help!!
Anthonyanthonysjo wrote:
> Is is possible to change the sender when using XP_Sendmail? I am
> sending a notification that reports are available in reporting
> services in a single email and want to change the sender from
> SQLSERVICEADMIN to something users will recgonize easily.
You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
HTH,
Stijn Verrept.|||Yes, I had found reference to that but my DBA's will push heavily on not
installing it. Is there another way?
"Stijn Verrept" wrote:
> anthonysjo wrote:
>
>
> You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
> --
> HTH,
> Stijn Verrept.
>|||As I know there is no way using the "friendly" name within XP_sendmail.
Once I had a commandline program which was able to send also via SMTP.
But this could be easily reprogrammed in .NET or another programming
language covering the same functionality. If you are interested in,
just send me a mail.
HTH, Jens Suessmeyer.
Showing posts with label sending. Show all posts
Showing posts with label sending. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Changing the file name when sending a report in a subscription
Hello...
When i send a report in a subscription (in excel format - or any other) the
file is created and send as a file with the name of the report. How can i
change the name of this file ?
ThanksOne solution for you might be to create linked reports and to create
subscriptions on those.
However if you are looking to create something where you can configure the
name of the report when the report is executed - say append a date and time
to the report's name - then you are going to either have to create a Custom
Delivery Extension, or you are going to have to build your own component
that you schedule independantly from Reporting Services that extracts the
Report via the SOAP interface, names the output file and delivers it to your
user.
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:89B65C23-7EDF-4B47-B259-7BB370FFB98C@.microsoft.com...
> Hello...
> When i send a report in a subscription (in excel format - or any other)
> the
> file is created and send as a file with the name of the report. How can i
> change the name of this file ?
> Thanks
When i send a report in a subscription (in excel format - or any other) the
file is created and send as a file with the name of the report. How can i
change the name of this file ?
ThanksOne solution for you might be to create linked reports and to create
subscriptions on those.
However if you are looking to create something where you can configure the
name of the report when the report is executed - say append a date and time
to the report's name - then you are going to either have to create a Custom
Delivery Extension, or you are going to have to build your own component
that you schedule independantly from Reporting Services that extracts the
Report via the SOAP interface, names the output file and delivers it to your
user.
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net
"Penker" <Penker@.discussions.microsoft.com> wrote in message
news:89B65C23-7EDF-4B47-B259-7BB370FFB98C@.microsoft.com...
> Hello...
> When i send a report in a subscription (in excel format - or any other)
> the
> file is created and send as a file with the name of the report. How can i
> change the name of this file ?
> Thanks
Tuesday, March 20, 2012
changing subscription email address in RS2000
Is there a way I can change the email address associated to sending timed
reports notifications to users?
Currently it is under my email address and I would like it to change to a
different email address.
TIA,
JacksonNevermind figured it out.
You need to edit the RSReportServer.config file. I had to do a find of the
email address I wanted to replace.
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:umjwsLDCHHA.3924@.TK2MSFTNGP02.phx.gbl...
> Is there a way I can change the email address associated to sending timed
> reports notifications to users?
> Currently it is under my email address and I would like it to change to a
> different email address.
> TIA,
> Jackson
>
>
reports notifications to users?
Currently it is under my email address and I would like it to change to a
different email address.
TIA,
JacksonNevermind figured it out.
You need to edit the RSReportServer.config file. I had to do a find of the
email address I wanted to replace.
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:umjwsLDCHHA.3924@.TK2MSFTNGP02.phx.gbl...
> Is there a way I can change the email address associated to sending timed
> reports notifications to users?
> Currently it is under my email address and I would like it to change to a
> different email address.
> TIA,
> Jackson
>
>
Subscribe to:
Posts (Atom)