Tom,
I am also trying to use the code. But the error I'm receiving is "Argument not Optional" Perhaps if you can point out where I have gone wrong, we could work through this together.
Here's a function I use to call the sub;
Function fun_sendnotes()
Call SendNotesMail("TEST SUB", "C:\Documents and Settings\schombud\Desktop\test.xls", "dave_r_schomburg@bankone.com", , "THIS IS A TEST"
End Function
AND HERE's WHAT THE SUB LOOKS LIKE;
Public Sub SendNotesMail(Subject As String, Attachment As String, Recipient As String, cc As String, BodyText As String, SaveIt As Boolean)
'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 NotesDocument
Dim MailDoc2 As Object
Dim AttachME As Object 'The attachment richtextfile object
Dim session As Object 'The notes session
Dim EmbedObj As Object 'The embedded object (Attachment)
Dim CurrentDatabase As String
Dim NotesSS As New NotesSession
Dim NotesDb As New NotesDatabase
Dim SendFolder As String
Dim view As NotesView
On Error GoTo Errshow:
NotesSS.Initialize ("password001"
' you can place your password here to go straight in if not logged in already
With NotesSS
Set NotesDb = .GetDatabase("CMHMS003/MS/SVR/BANCONE", "mail1\davrscho.nsf", False)
End With
With NotesDb
'Start a session to notes
Set session = CreateObject("Notes.NotesSession"
'Get the sessions username and then calculate the mail file name
'You may or may not need this as for MailDBname with some systems you
'can pass an empty string
UserName = session.UserName
MailDbName = NotesDb
Set MailDb = session.GetDatabase("", MailDbName)
If Not (MailDb.IsOpen) = True Then MailDb.OPENMAIL
'Set up the new mail document
Set MailDoc = MailDb.CreateDocument
With MailDoc
.Form = "Memo"
.sendto = Recipient
.CopyTo = cc
.Subject = Subject
.Body = BodyText
.SaveMessageOnSend = SaveIt
.principal = "user account" '(if different to your default account name)
'.PutInFolder SendFolder, True '(if you need a copy in the sent folder)
End With
'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
End With
'MailDoc.PutInFolder (SendFolder)
'Send the document
MailDoc.Send 1, Recipient
MsgBox "Sent!", vbExclamation
Cleanup:
Set MailDb = Nothing
Set MailDoc = Nothing
Set AttachME = Nothing
Set session = Nothing
Set EmbedObj = Nothing
Exit Sub
Errshow:
MsgBox (Err.Description)
GoTo Cleanup
End Sub
ANY HELP WOULD HELP A HEAP!
