[Solved] Can I burst to multiple email addresses?

[agorsky]

Hello--

I have a simple need but I can't find a solution.Ã,  I have a report which uses a list report.Ã,  It is grouped by Sales Manager and then Account Executive.Ã,  I want bursting to key off of the Account Executive and burst to both Manager and AE.Ã, 
I thought I had a solution by creating a DataItem within the Query that will combine the Mgr & AE email.Ã,  Ex: [Mgr Email] + ',' + [AE Email].Ã,  Although an error is not thrown I am not receiving the emails.Ã,  I have tried replacing the ',' with a ';' but this did not work either.
Any ideas or recommendations?Ã,  Thanks for all the help.Ã,  Cognoise is such a valuable resource!!

Aaron

[sir_jeroen]

Off course... You can assign multiple addresses to your burst key. But does it work for 1 user?
First make sure that works... And why don't you assign real email addresses instead of aliases? Maybe that works.

An other option is to create mailing list and burst to that email address..

[agorsky]

Hi--

It does work for 1 user.  I am not sure what you mean by real email addresses vs aliases. Can you elaborate? The Mgr and AE email addresses are pulled from our employee database.  The problem with creating a mailing list is that I would need a mailing list for each AE.  This report needs to be burst to the AE but also to their individual manager.  If I create a mailing list then I will need to maintain that everytime we add an Account Executive. 

Thanks again,

Aaron

[Darek]

When you specify bursting options during design time, you need to specify email targets, not directory entries.

[agorsky]

Hi Darek--

I forgot to mention in my previous post that I am specifying email targets.  Have you been able to specify multiple email addresses in the Item and have them delivered successfully?

Thanks,

Aaron

[agorsky]

Has anyone been able to successfully email to multiple people from 1 key before?  Example: "email1@address.com,email2@address.com"  I called Cognos and I am awaiting a call from their tech department.

Thanks,

Aaron

[Skidly]

We are setting up email groups in Outlook to burst to multiple recipients.
Then just burst to that email group.

[agorsky]

That is an option but not a good solution for us.   The report is grouped by Manager and then Sales Person.  I want the email to burst to the Sales Person and also to their Manager.  I have both email addresses in the query.  If I was to create a distribution list then I would need a list for each Sales Person.  My only other option is to create 2 versions of the same report.  One report will burst off of the manager and the other off of the Sales Person. 

Aaron

[Darek]

I would try separating multiple addresses with semicolons.

[SueC]

Aaron,

How were you able to finally resolve this issue?  Did you send the manager a single report for all his sales reps or a report for each sales rep?

Inquiring minds want to know!  Thanks!

Sue

[Mridder]

I am dealing with the exact same issue. While the issue seems to be solved (judging by the topic title), I cannot seem to find the solution. What to do?  ???

[angelana22]

I am in the same situation. Has anyone find a way to solve this?

Thanks

[B]

It may not be what you were after as I may have misunderstood what you require and I know its not completely within the realms of Cognos but we had a similar sort of thing where we had one report but we wanted to burst to potentially to hundreds of different recipients (emails to hotels dependant on if bookings had been made in them during the previous days trading) and we bought a product called pdfEburst.  We embed the email address at the top of each PDF page, it then goes through the PDF doc no matter how big it is, and splits, bursts and emails the report based on that email address.

Admittedly not a completely automated process as we have it on a local OC, send the PDF report to a user who then adds the PDF doc to the pdfEburst queue for this to be done but am sure a clever soul could automate it somehow.  And rubbish unless the report is PDF obviously!  :-\

Not sure if that helps anyone but saves a lot of time on how they used to do it, which was print the pdf doc out and fax!

[dbrys]

It's a pity that the solution can't be found in this post so here it comes - in your case the easiest way to do is to create a query containing the manager's email item and another query containing the sales email.
Next - Union both queries.
Then point the burst recipient to the unioned query.

That will work.

[Sirolway]

You can burst to multiple email addresses simply by

a. Providing a comma-delimited list of email addresses in your Recipients data item.

This is valid:
'me@whatever.com, you@whateveer.com, them@whatever.com'

This is also valid (mixing database items & hard coded, e.g. for cc'ing yourself)
[Presentation].[Employees].[Employee Email]+', me@whatever.com, you@whatever.com'

b. Ensuring that you set 'Report Studio > File menu > Burst Options > Burst Recipient > Type' to Email Addresses.
Cognos gets confused by multiple emails if you leave this at Automatic. It will assume you're entering directory namespace IDs and give you an error about invalid classes.

This definitely works - I've just burst to a heap of sales reps, cc'ing me, bosses etc using thie technique.

Using semi-colon delimited lists of email addresses *seems* to work but the emails never get sent - you should use comma-delimited instead.

[andrewpontes]

Thanks Syrolway for your simple and spot-on answer. I was searching for a solution for multiple hard-coded email addresses in the burst email recipients.

[cognosnew]

I tried your  solution Sirolway. But it doesnt CC..it adds the people to 'TO' not CC.
Any help would be greatly appreciated.

Thanks

[MFGF]

I tried your  solution Sirolway. But it doesnt CC..it adds the people to 'TO' not CC.
Any help would be greatly appreciated.

Thanks

Are you doing this in ReportNet or Cognos 10??

MF.

[khabaleshri]

Thanks Sirloway. This portal has solution for every queries.
Comma separated email address worked if we want to send report to multiple people who belongs to multiple burst key.
Take care there should not be space after comma for second mail. Ex case when business owner= 'Audit' then 'me@abc.com,you@abc.com' end

Extension to this method. If user belongs to two burst key ex M will receive two report Audit and operational risk respectively then how to send one consolidated file (Audit + Operational risk data ) instead of two ??