Is it possible to create a data driven subscription that supplies the from address based on which brand of my company is sending out the email? Or even if I'm representing a single brand, I need to use different email addresses such as customerservice or accounting or system.admin, etc. This cannot be a rare situation, what do all of you do to address this concern? Am I missing something obvious? Thanks, Anand

Please try adding email addresses in the data driven dataset separated by semi colons ';'Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi, I think it is not possible as email will be sent using the address defined in configuration. If you are interested in reply to email address based on brand then you can get reply to email address from dataset and select the filed in reply to option in datadriven setup pages. Thanks

This is not possible unless you wish to re-start the service everytime you need to change the address. The service configuration allows only one email address and does not allow it to be chosen. You would have to modify the service configuation and re-start every time you needed to change the address.Jeff Block t:@sqlDictum (http://www.twitter.com/sqlDictum)

Sorry, I'm not talking about the "To" addresses; I'm talking about sending the email "From" different emails.

So what do you do to address my issue? How do you handle it in your own company? Thanks, Anand.

Do some research on SSRS report delivery using SSIS. I dont see any other option to dynamically define from email in data driven subscription.

Thanks AAlby, your answer was very helpful. I can't imagine why Microsoft can't provide this feature, it's rather common I would think for companies to send emails to their customers and many companies have multiple brands. What bothers me most is that I don't know how all of those companies are managing without this simple feature and no one seems to know.

Ran into same issue and was the last nail in the coffin for SSRS at my company. Just too many limitations - such as no dynamic column widths (tables & textboxes), dynamic sub reports, or dynamic report page sizing (the list goes on and on)... and you can't do any of these common things. And why the heck can't I set a FROM address without jumping threw flaming hoops???? It just blows my mind. I now tell everyone that will listen - if you need anything other than the most bone head simple report don't go with SSRS. It’s been around for years and years and yet sucks so bad.

Thanks for sharing my frustration Coffe, so what do you use instead or what do you advise instead? Thanks, Anand

Hi Anand, I'm curious to know why somebody needs multiple "From" address. If I think "Outlook" vice isn't it will mess up things??, also suppose if we enter two email address (one might be correct another might be wrong email) than how things will be handled, remember I said might be). Thanks KumarKG, MCTS

Hi Anand, I'm curious to know why somebody needs multiple "From" address. If I think "Outlook" vice isn't it will mess up things??, also suppose if we enter two email address (one might be correct another might be wrong email) than how things will be handled, remember I said might be). Thanks KumarKG, MCTS

Hi Kumar, Not sure if you read my original post question or my subsequent comments, but let's say I create a report for invoices and I send them every evening, I'd like the email to be sent from "accounting@company1.com" and say I create another report for daily sales which I send to my managers, I'd like the email sent from "reports@company1.com", or on the other hand if say I had 2 companies, I'd like to send invoices to the second company customers from "accounting@company2.com". I don't mean multiple from addresses in 1 email, I mean the ability to create report subscriptions where I can select a from email address, instead of having the report server configuration changed every time. Regards, Anand

As alreaddy been dicussed in the forum, this feature is presently not available within SSRS data driven subscription. What can be suggested I guess is to create the data driven subscription to save the files to a shared folder. Add the field "from address" also to the table used in the above data driven subscription. Then write an SSIS package to use this table and send the emails. SSIS "send email task" can be configured to set the from address, to address, cc, bcc, attachment etc. dynamically. However if you would like to submit a feedback to Microsoft Connect requesting this feature, you can do so at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Anand - I must of been in a bad mood that day. Sorry for the rant. Unfortunately, there isn't a complete solution that we found that would fit our needs. Nevertheless, we've phased out SSRS's built in site for our own custom made report server site, which hasn't been a cake walk getting in place for sure but not impossible and the satisfaction for finally being able to get around the many SSRS limitations has been nice to say the least. What we're doing is running our existing SSRS reports from inside our site and for the many cases where SSRS fails to be flexible enough, we design the reports in HTML/ASP.Net – using third party components for doing charts and fancy gauges for KPI reports and generating PDFs etc. So we now have the ability to have both SSRS and our custom reports in one site – which is great. I personally would love just to pull the plug on SSRS but too much has been invested in it and will take a while to completely phase out (if ever since occasionally still making them for SSRS). Coffe PS: On our new site after generating a PDF of a SSRS report we can send that PDF with whatever FROM field we want since it's our page that drives the report! we also get around the report page size limit by first fetching the XML, modifying it on the fly to the correct size that the user wants (Letter or A4 / portrait or landscape) and sending back via web services to SSRS to render. None of this was easy to do and I've spent a crazy amount of time on this project!

Thanks Coffe for sharing your experience!