Lotus Notes & BO 1

[funkmonsteruk]

I have an automated BO report, can i get BO to automaticallty e-mail to some of my collegues using lotus notes?

 

[skrandel]

Using scripting. Notes is a MAPI product, so you can do it. I don't have a sample to post, but I know it can be done. I bet you can find a sample at busobj.forumtopics.com or on the BO Knowledge Exchange.

You'd have to install Notes on your Broadcast Agent server. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[deaco]

I did something similar from Access not from BOb. It may help, using Access VBA, should just need changing a bit into the BOb equivilant if needed at all. Lotus Notes needs to be running and logged in for this version to work. Not to clean but it works.

Function NotesMailSend(strModtager As String, strSubj As String, strBody As String)
 
On Error GoTo Err_NotesMailSend
 
    Dim objNotes As Object
    Dim objNotesDB As Object
    Dim objNotesMailDoc As Object
 
    Set objNotes = GetObject("", "Notes.Notessession")
   
    Set objNotesDB = objNotes.getdatabase("", "")
 
    Call objNotesDB.openmail
    Set objNotesMailDoc = objNotesDB.CreateDocument
 
    Call objNotesMailDoc.replaceitemvalue("SendTo", strModtager)
    Call objNotesMailDoc.replaceitemvalue("Subject", strSubj)
    Call objNotesMailDoc.replaceitemvalue("Body", strBody)
 
    Call objNotesMailDoc.Send(False)
  
    Set objNotes = Nothing
 
Exit_NotesMailSend:
    Exit Function
 
Err_NotesMailSend:
    Resume Exit_NotesMailSend
 
End Function

 

[Andrew555]

funkmonster

Did you ever get this to work? I have the same problem - I'm trying to get BO to refresh and mail a report using Lotus Notes, I've found some good pieces of code in this forum for refreshing and saving to a file but can't get the email happening...

 

[funkmonsteruk]

Not tried it yet Andrew, decided on another solution to this problem.

I will give it a go and let you know

 

[deaco]

Have you managed to get this working as yet?

 

[funkmonsteruk]

Yes, your code (with a few alterations) worked like a dream....

Decided on another solution in the end, but the code definitely works.