Showing posts with label companies. Show all posts
Showing posts with label companies. Show all posts

Thursday, March 22, 2012

Email through SQL

I am trying to setup my sql to send automatic emails to different companies but I am not doing so well. The user puts an email address in the database and then presses a button (command button) that will execute a stored procedure xp_sendmail to a recepient. I need to know how to include read receipts and delivery receipts into the stored procedure, because right now its set up in his outlook as a rule to do this and I want to set it up in sql. The user deals with companies and these companies have several contacts with several email addresses which sql will store in a seperate table.Hiya Des...I'm sure others more knowledgeable will soon come to your rescue, but I don't think there are that kind of specific email options in xp_sendmail. However, Though I use the xp_sendmail quite a bit, I am no expert (as my recent thread posting shows).

HOWEVER, that said, perhaps you could send a "regular" email to your user from SQL Server, then set up some rules in Outlook to massage the necessary options and forward the email on to the appropriate customers? I know that's kinda a round-about way to get there, but it seems to me that it would work if nobody comes up with a definitive answer from SQL Server...

Just a thought

email subscriptions disabled

What options do I have if email subscriptions on my companies report server have been disabled. I need to run a report daily which will send to a list of receipents. The email feature would be perfect for this but our company (10000+ people) do not want our email systems clogged with big reports.

Hi,
you can enable email subscription modifying RsReportServer.config :
...............
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>YOUSMTPSERVER</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName>AAAA</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
........
Then, in email subscription configuration (http://localhost/reports....)
you check that the email sent contains link to report.

Friday, March 9, 2012

Email Address in subscription

My companies email domain options for email address are diamondjo.com or
evangelinedowns.com.
When I set up a subscription is it possible to only put in the alias name
such as 'something' instead of somthing@.diamondjo.com? When I am in Outlook
creating an address these two domains are integrated into one address book.
I know each domain has there own exchange server.
If so, how.
Thanks.Hi Brian.
I think you're going to need to supply the fully qualified email address.
Reporting Services uses SMTP to send mail and it needs to the fully
qualified address to know where to relay the email to.
Is this a workaround to another problem?
-Tim
"Brian Shannon" <brian.shannon@.diamondjo.com> wrote in message
news:uHeqRQ$kGHA.4444@.TK2MSFTNGP02.phx.gbl...
> My companies email domain options for email address are diamondjo.com or
> evangelinedowns.com.
> When I set up a subscription is it possible to only put in the alias name
> such as 'something' instead of somthing@.diamondjo.com? When I am in
> Outlook creating an address these two domains are integrated into one
> address book. I know each domain has there own exchange server.
> If so, how.
> Thanks.
>|||This is not a workaround. I am new to RS and figured that being a MS
product it would closely integrate with Exchange. I didn't want to be fully
qualifiying email if I didn't have to.
Thanks for your response.
"Tim Dot NoSpam" <Tim@.MindYourSpammy.spam> wrote in message
news:%23ldKm9GlGHA.4284@.TK2MSFTNGP05.phx.gbl...
> Hi Brian.
> I think you're going to need to supply the fully qualified email address.
> Reporting Services uses SMTP to send mail and it needs to the fully
> qualified address to know where to relay the email to.
> Is this a workaround to another problem?
> -Tim
> "Brian Shannon" <brian.shannon@.diamondjo.com> wrote in message
> news:uHeqRQ$kGHA.4444@.TK2MSFTNGP02.phx.gbl...
>> My companies email domain options for email address are diamondjo.com or
>> evangelinedowns.com.
>> When I set up a subscription is it possible to only put in the alias name
>> such as 'something' instead of somthing@.diamondjo.com? When I am in
>> Outlook creating an address these two domains are integrated into one
>> address book. I know each domain has there own exchange server.
>> If so, how.
>> Thanks.
>