الحمد لله تم الحل
DoCmd.OutputTo acOutputForm, "ALL_PENDING", "ExcelWorkbook(*.xlsx)", "\\PC1689\ Common Folder\Pending\PENDING DELIVERY RECEIPTS - DEPOT.xlsx", False, "", 0, acExportQualityScreen
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tallpending", "\\PC1689\Common Folder\Pending\PENDING DELIVERY RECEIPTS - DEPOT.xlsx", True, "Total "
DoCmd.OutputTo acOutputReport, "PENDING _REPORT", "PDFFormat(*.pdf)", "\\PC1689\ Common Folder\Pending\PENDING DELIVERY RECEIPTS - .pdf ", False, "", 0, acExportQualityScreen
Dim mess_body As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.BodyFormat = olFormatRichText
.To = "اسم الايميل المرسل"
.Subject = "عنوان الموضوع"
.HTMLBody = "نص الرسالة"
.Attachments.Add ("المرفق الاول")
.Attachments.Add ("المرفق الثانى")
.Send
End With