scheduling multiple reports to a single email recipients 1

[crsdev]

Hello friends,
Does anyone know how to schedule multiple reports in a single email to a single mail recipient address.
I am trying to schedule 4 excel format report to someone in a single email instead of having 4 different emails.

Thanks.

 

[MJRBIM]

I think the APOS Report Package Booster can do this...there are probably other 3rd party product that can also do it listed on-line.

 

[crsdev]

you'r saying it can't be done in a single without a third party too.

 

[hilfy]

You might be able to do this with Packages in BusinessObjects. I haven't worked with them but they're groupings of reports that run together (I'm not sure if they're simultaneous or consecutive) from one schedule. You have to publish the reports as a package.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[MJRBIM]

The default setting for SMTP DESTINATION is one e-mail per attachment. Report Packages within BOE-XI don't do this either.

You can ONLY send multiple attachments in a single e-mail by buying a 3rd party tool - or writing your own JAVA or .NET application.

 

[davida37]

This is all very interesting... 2 other questions...

Email format:
Can you change the email format - so far I have them working in plain text only. looks very rudimentary/basic.

Report in HTML body of report?
Can you put the report as html in the report? or is this something only a 3rd party tool can do if can at all?

thanks

 

[jedownsjr]

We do multiple report attachments using a poor-man's method. This works on our Windows servers with SMTP and may be helpful for you or others with the same issue. It saved us from having to purchase a 3rd party tool by utilizing built-in Windows functionlity.

I use this code in a simple VB program (not VB.net, but should be similar code for that or Linux or other platforms). I just create a simple VB executable, fill in my email information and file locations which are run in CE and output to disk on the server, then launch the VB executable using a Windows scheduled task.

Type "CDONTS" into a search engine if you need to research the topic. Good luck!

THE CODE:

'--------------------------------------------------
Set MyCDONTSMail = CreateObject("CDONTS.NewMail")
MyCDONTSMail.From = "Sender@somedomain.com"
MyCDONTSMail.To = "ToRecipient@somedomain.com"
MyCDONTSMail.Bcc = "BCCRecipient@somedomain.com"
MyCDONTSMail.Subject = "Put Email Subject Here"
MyBody = "Put 1st line of email here." & vbCrLf
MyBody = MyBody & vbCr
MyBody = MyBody & "Keep adding more lines to your email. Use vbCrLf for line breaks and spacing." & vbCrLf
MyBody = MyBody & vbCrLf
MyCDONTSMail.Body = MyBody
MyCDONTSMail.AttachFile ("c:\FolderNameHere\Report1.pdf")
MyCDONTSMail.AttachFile ("c:\FolderNameHere\Report2.pdf")
MyCDONTSMail.AttachFile ("c:\FolderNameHere\Report3.pdf")
MyCDONTSMail.Importance = 1 '0=Low; 1=Normal; 2=High
MyCDONTSMail.Send
Set MyCDONTSMail = Nothing
'--------------------------------------------------

 

[davida37]

this is great. thanks a bunch.