Putting BO Docs in a E-mails body

system · February 10, 2000, 9:53am

Hi Listner,

Has anyone had experience with mailing BO Docs (via standarda E-Mail clients like MS Outlook).
I do not want to use the standard BO feature of mailing it as an attachment. This method requires the correspondent to have BO as well. I really want to put the report in the ‘body’ of the mail message.

Kind regards,

Paul Vandenhende
BusinessObjects Consultant
Tel : 0477/390.637
http:/www.sofico.be

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 9:54am

Hi Listner,

Has anyone had experience with mailing BO Docs (via standarda E-Mail clients like MS Outlook).
I do not want to use the standard BO feature of mailing it as an attachment. This method requires the correspondent to have BO as well. I really want to put the report in the ‘body’ of the mail message.

You can export (save) the report as a text file and send it as an attachment or cut and paste it in the body of the message.

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 10:24am

Bertrand,

Thank you for your reply. However, the point is, I want to have the mail send via a macro or whatever other automatic way.

Thanks anyway,

Paul Vandenhende
BusinessObjects Consultant
Tel : 0477/390.637
http:/www.sofico.be

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 1:49pm

This probably won’t help you, but we have had success distributing BO reports via e-mail in HTML format. We are using Groupwise 5.5 and we send a BO report (saved as HTML first) as an HTML attachment. When the user opens the e-mail it immediately comes up as an HTML page. No need to open the BO client, no need for the user to click on another link. It’s quite efficient. However, I have not tested this method with other e-mail clients.

Jim McGregor

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 1:55pm

Just a thought, have you checked out Microsoft’s Digital DashBoards? Instead of emailing the reports you could broadcast them to a directory where Outlook could read them as the home page.
Simon

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 4:39pm

If you don’t mind saving the reports as text you could use a utility like SPIMail, you could download it @ http://www.capitexkonsult.com . I have not done a thorough search but if anyone knows of a command line mail utility that allows you to alter the header (MIME or Content-type) of the email you could actually send an html page as the email. Perhaps you could request that from the creator of the previously mentioned utility.

Greg
2B||!2B

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 6:03pm

I bought this utility awhile ago. If you are brave enough, you can also purchase the source code (for more money) and alter the code yourself. Simon

Listserv Archives (BOB member since 2002-06-25)

system · February 10, 2000, 9:00pm

Paul:
The following is sample vbcode which may shed some insight on the task of which you are trying to create.
This code simply creates one email based on the users who have access. To have a procedure that sends multiple email attachments to multiple users is an easy task but requires a little bit more code. I do have that written but without the attachment piece. If you would like me to post it let me know.

’ Module : mdOutlook
’ Description: Send management reports via business rules ’ Procedures : GotoMsg

’ Created : 08/17/1999 John Sullivan
’ Modified :
’ 09/10/1999
’ -------------------------------------------------- Option Compare Database
Option Explicit

Public Function GotoMsg(Optional varAttachmentPath)
’ Comments :
’ Parameters : varAttachmentPath -
’ Returns : -
’ Created :
’ Modified :
’
’ -------------------------------------------------------- On Error GoTo PROC_ERR
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment Dim dbsODB As Database
Dim rstOST As Recordset
Dim strTSASUB As String
Dim strTSAMsg As String
Dim strDateHolder As String

strDateHolder = InputBox(“Please Enter the date of the Work Item Meeting”, “Input Required”, “July 27”)
strTSASUB = “Work Item Ranking”
strTSAMsg = "Attached are the work item ranking lists for the monthly ranking meeting on Tuesday, " & strDateHolder & “, from 3:00 to 4:00 p.m., in room 5A5-1. These reflect the updates from last month’s ranking session. Please review and be prepared to discuss any changes needed.” & vbCrLf & vbCrLf

Set dbsODB = CurrentDb()
Set rstOST = dbsODB.OpenRecordset(“qryNotification”, dbOpenSnapshot)

Set objOutlook = CreateObject(“Outlook.Application”) Set objOutlookMsg = objOutlook.CreateItem(olMailItem) With objOutlookMsg

Do While Not rstOST.EOF

Set objOutlookRecip = .Recipients.Add(rstOST![Name]) If rstOST![Type] = “To” Then
objOutlookRecip.Type = olTo
Else
objOutlookRecip.Type = olCC
End If

rstOST.MoveNext
Loop
objOutlookRecip.Resolve

.Subject = strTSASUB
.Body = strTSAMsg
.Importance = olImportanceHigh
Set objOutlookAttach = .Attachments.Add(“c:\rptranking.rtf”) Set objOutlookAttach = .Attachments.Add(“c:\rptDescriptions.rtf”) Set objOutlookAttach = .Attachments.Add(“c:\rptSponsors.rtf”) objOutlookRecip.Resolve
.Display

End With
Set objOutlook = Nothing
rstOST.Close

'MsgBox (“Email Messages Created!”)
Exit Function

PROC_ERR:
MsgBox "The following error occured: " & Error$ Resume Next
End Function

Listserv Archives (BOB member since 2002-06-25)