par jfarissi » 09 Oct 2009 à 12:48
Sub Initialize
Dim session As New notessession
Dim workspace As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Dim item As notesitem
Set uidoc = workspace.CurrentDocument
Dim subject As String, bodytext As String, linkmsg As String, ordernum As String, recipient As String,NumeroContrat As String
Dim database As NotesDatabase
Dim doc,doc1 As NotesDocument
Dim collection As NotesDocumentCollection
Dim view As notesview
Dim mdate1V , mdate2V As Variant
Set database = session.currentdatabase
Set view = database.getview("vNum")
Set doc = view.getfirstdocument
Do While Not(doc Is Nothing)
Set mdate1V = New notesdatetime(doc.Date_Alerte(0))
Set mdate2V = New notesdatetime(Now)
If mdate1V.Timedifference(mdate2V) = 0 Then
'Messagebox Cstr(Format(Now,"dd/mm/yyyy"))
NumeroContrat = doc.Numero_Contrat(0)
subject = "Relance Contrat (" & NumeroContrat & ")"
bodytext = " Une relance a été prevue pour le contrat (" & NumeroContrat & ") a la date du ("& doc.Date_Alerte(0) &")"
linkmsg = "Lien du contrat #" & NumeroContrat
recipient = doc.RC(0)
Call sendMail(subject, bodytext, recipient, doc, linkmsg)
End If
Set doc=view.getnextdocument(doc)
Loop
End Sub