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 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
Option Compare Database
Function cmdMAIL()
Dim blret As Boolean
Dim astrFichiers(1 To 3) As String
Dim rst As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb()
Set rst = db.OpenRecordset("SELECT * from [TbEcart]")
If Not rst.EOF Then
'strDest = "samueltaschereau@cyber3d.ca;clermonthudon@cyber3d.ca;davenadeau@cyber3d.ca;linebergeron@cyber3d.ca"
strDest = "linebergeron@cyber3d.ca"
strObj = "Cartouches a ré-étiquetter"
strMsg = "SVP modifier les étiquettes si applicable"
astrFichiers(1) = "X:\Programme Access\LISTE DE PRIX\Prix Synnex\RapEcart.pdf"
SendOLMail strDest, strObj, strMsg, False, astrFichiers
DoCmd.OpenReport "RapEcart", acViewPreview, , , acHidden
DoCmd.OutputTo acOutputReport, "RapEcart", "PDF", "X:\Programme Access\LISTE DE PRIX\Prix Synnex\RapEcart.pdf"
MsgBox ("Liste de Changements de Prix Envoyée")
Else
MsgBox ("Aucun changement de prix effectué dans le rapport")
End If
End Function
Public Sub SendOLMail( _
ByVal strDest As String, _
ByVal strObj As String, _
ByVal strMsg As String, _
ByVal blnEdit As Boolean, _
Optional ByVal avarFichiers As Variant)
Dim ol As Outlook.Application
Dim mi As Outlook.MailItem
Dim varPJ As Variant
On Error GoTo OLMailErr
Set ol = New Outlook.Application
Set mi = ol.CreateItem(olMailItem)
With mi
.To = strDest
.Subject = strObj
.Body = strMsg
.Attachments.Add "X:\Programme Access\LISTE DE PRIX\Prix Synnex\RapEcart.pdf"
If blnEdit Then
.Display
Else
.Send
End If
End With
Set mi = Nothing
Set ol = Nothing
Exit Sub
OLMailErr:
MsgBox "Erreur : " & Err.Number & vbCrLf & Err.Description
Exit Sub
End Sub |
Partager