Public Function SendNotesMail(SendTo As Variant, CopyTo As Variant, BlindCopyTo _
  As Variant, _
    Subject As String, Body As String, Attachment As String, SaveIt As Boolean) _
    As String
 
'Set up the objects required for Automation into lotus notes
Dim Maildb As Object 'The mail database
Dim UserName As String 'The current users notes name
Dim MailDbName As String 'THe current users notes mail database name
Dim MailDoc As Object 'The mail document itself
Dim AttachME As Object 'The attachment richtextfile object
Dim Session As Object 'The notes session
Dim EmbedObj As Object 'The embedded object (Attachment)
 
    On Error GoTo Fehler
 
    Set Session = GetObject("", "Notes.NotesSession")
 
    If Session Is Nothing Then
        Set Session = CreateObject("Notes.NotesSession")
    End If
 
    Set Maildb = Session.GETDATABASE("", Benutzer + ".nfs")
 
    If Not Maildb.IsOpen = True Then
        Maildb.OPENMAIL
    End If
 
    'Set up the new mail document
    Set MailDoc = Maildb.CreateDocument
 
    MailDoc.Form = "Memo"
    MailDoc.SendTo = SendTo
    MailDoc.CopyTo = CopyTo
    MailDoc.BlindCopyTo = BlindCopyTo
    MailDoc.Subject = Subject
    MailDoc.Body = Body
    MailDoc.SaveMessageOnSend = SaveIt
 
    'Set up the embedded object and attachment and attach it
    If Attachment <> "" Then
        Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment")
        Set EmbedObj = AttachME.EMBEDOBJECT(1454, "", Attachment, "Attachment")
        MailDoc.CREATERICHTEXTITEM ("Attachment")
    End If
 
    'Send the document
    MailDoc.PostedDate = Now() 'Gets the mail to appear in the sent items folder
    MailDoc.Send 0, SendTo
 
    'Clean Up
    Set Maildb = Nothing
    Set MailDoc = Nothing
    Set AttachME = Nothing
    Set Session = Nothing
    Set EmbedObj = Nothing
 
Exit Function
 
Fehler:
    SendNotesMail = Err.Description
End Function