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
| Private Sub cmdEmail_Click()
DoCmd.Requery
On Error GoTo Err_cmdEmail_Click
Dim strDocName1 As String
Dim strDocName2 As String
Dim strEmail As String
Dim strEmailCC As String
Dim strMailSubject As String
Dim strMsg As String
strDocName1 = "Global_Report"
strDocName2 = "Report_Line"
strEmail = Me.email
strEmailCC = Me.EmailCC
strMailSubject = " Perfo for" & Me.DeroulMenuGeneralDateDebut & " " & Me.DeroulMenuGeneralDateDFin
strMsg = "Dear,"
DoCmd.SendObject objecttype:=acSendReport, _
ObjectName:=strDocName1, outputformat:=acFormatPDF, _
To:=strEmail, CC:=strEmailCC, Subject:=strMailSubject, MessageText:=strMsg
DoCmd.SendObject objecttype:=acSendReport, _
ObjectName:=strDocName2, outputformat:=acFormatXLS, _
To:=strEmail, CC:=strEmailCC, Subject:=strMailSubject, MessageText:=strMsg
Exit_cmdEmail_Click:
Exit Sub
Err_cmdEmail_Click:
MsgBox Err.Description
Resume Exit_cmdEmail_Click
End Sub |
Partager