1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
| Sub EmailFile()
' Declaration des variables
Dim UserName As String
Dim MailDbName As String
Dim mailDB As Object
Dim mailDoc As Object
Dim AttachME As Object
Dim Session As Object
Dim EmbedObj1 As Object
' Création du lien avec lotus
Set Session = CreateObject("Notes.NotesSession")
UserName = Session.UserName
MailDbName = Left$(UserName, 1) & Right$(UserName, (Len(UserName) - InStr(1, UserName, " "))) & ".nsf"
Set mailDB = Session.GetDatabase("", MailDbName)
If mailDB.IsOpen = True Then
Else
mailDB.OPENMAIL
End If
' Création du mail + renseignement des informations
Set mailDoc = mailDB.CreateDocument
mailDoc.Form = "Memo"
mailDoc.SendTo = "mail@gmail.com"
mailDoc.Subject = Sujet"
' Construction du corps du message
'Set objNotesField = mailDoc.CreateRichTextItem("Body")
'With objNotesField
mailDoc.Body = "texte du mail"
'Affichage du mail dans Lotus Notes
Set workspace = CreateObject("Notes.NotesUIWorkspace")
Call workspace.EDITDOCUMENT(True, mailDoc)
'FIELDSETTEXT("Body", Body)
' Supresssion des varibles
Set mailDB = Nothing
Set mailDoc = Nothing
Set AttachME = Nothing
Set Session = Nothing
Set EmbedObj1 = Nothing
errorhandler1:
Set mailDB = Nothing
Set mailDoc = Nothing
Set AttachME = Nothing
Set Session = Nothing
Set EmbedObj1 = Nothing
With Application
.ScreenUpdating = True
.DisplayAlerts = True
End With
End Sub |
Partager