Author Topic: [Solved] Can I burst to multiple email addresses?  (Read 34466 times)

Offline Cognos Apprentice

  • Full Member
  • ***
  • Join Date: Sep 2005
  • Posts: 18
  • Forum Citizenship: +1/-0
[Solved] Can I burst to multiple email addresses?
« on: 18 Nov 2005 11:30:17 am »
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

« Last Edit: 09 Dec 2005 05:02:06 pm by Cognos Apprentice »

Offline ReportNet Addict

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Sep 2005
  • Posts: 957
  • Forum Citizenship: +65/-41
  • Creator of the Impact Suite
    • The Impact Suite
Re: Can I burst to multiple email addresses?
« Reply #1 on: 18 Nov 2005 12:30:50 pm »
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..

Offline Cognos Apprentice

  • Full Member
  • ***
  • Join Date: Sep 2005
  • Posts: 18
  • Forum Citizenship: +1/-0
Re: Can I burst to multiple email addresses?
« Reply #2 on: 18 Nov 2005 12:51:05 pm »
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

  • Guest
Re: Can I burst to multiple email addresses?
« Reply #3 on: 18 Nov 2005 01:53:55 pm »
When you specify bursting options during design time, you need to specify email targets, not directory entries.

Offline Cognos Apprentice

  • Full Member
  • ***
  • Join Date: Sep 2005
  • Posts: 18
  • Forum Citizenship: +1/-0
Re: Can I burst to multiple email addresses?
« Reply #4 on: 18 Nov 2005 03:10:08 pm »
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

Offline Cognos Apprentice

  • Full Member
  • ***
  • Join Date: Sep 2005
  • Posts: 18
  • Forum Citizenship: +1/-0
Re: Can I burst to multiple email addresses?
« Reply #5 on: 21 Nov 2005 10:59:36 am »
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

Offline Skidly

  • Full Member
  • ***
  • Join Date: Jul 2005
  • Posts: 14
  • Forum Citizenship: +1/-0
Re: Can I burst to multiple email addresses?
« Reply #6 on: 21 Nov 2005 11:14:50 am »
We are setting up email groups in Outlook to burst to multiple recipients.
Then just burst to that email group.

Offline Cognos Apprentice

  • Full Member
  • ***
  • Join Date: Sep 2005
  • Posts: 18
  • Forum Citizenship: +1/-0
Re: Can I burst to multiple email addresses?
« Reply #7 on: 21 Nov 2005 11:49:26 am »
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

  • Guest
Re: [Solved] Can I burst to multiple email addresses?
« Reply #8 on: 17 Jan 2006 09:53:23 pm »
I would try separating multiple addresses with semicolons.

Offline SueC

  • Global Moderator
  • Senior Member
  • *****
  • Join Date: Nov 2005
  • Posts: 62
  • Forum Citizenship: +3/-0
Re: [Solved] Can I burst to multiple email addresses?
« Reply #9 on: 26 Jan 2006 10:57:36 am »
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

Offline Mridder

  • Associate
  • **
  • Join Date: Nov 2006
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: [Solved] Can I burst to multiple email addresses?
« Reply #10 on: 29 Jan 2007 09:54:40 am »
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?  ???

Offline angelana22

  • Associate
  • **
  • Join Date: Feb 2008
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: [Solved] Can I burst to multiple email addresses?
« Reply #11 on: 20 Feb 2008 04:41:13 pm »
I am in the same situation. Has anyone find a way to solve this?

Thanks

Offline B

  • Full Member
  • ***
  • Join Date: Nov 2005
  • Posts: 10
  • Forum Citizenship: +0/-0
Re: [Solved] Can I burst to multiple email addresses?
« Reply #12 on: 21 Feb 2008 02:44:24 am »
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!

Offline dbrys

  • Associate
  • **
  • Join Date: Feb 2011
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: [Solved] Can I burst to multiple email addresses?
« Reply #13 on: 22 Feb 2011 06:00:43 am »
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.

Offline Sirolway

  • Associate
  • **
  • Join Date: Mar 2012
  • Posts: 1
  • Forum Citizenship: +1/-0
Re: [Solved] Can I burst to multiple email addresses?
« Reply #14 on: 19 Mar 2012 11:40:45 am »
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.

 


       
Twittear