Send a table through email : Email « Outlook « VBA / Excel / Access / Word

Send a table through email


Sub TestSendObject()
    DoCmd.SendObject acSendTable, "tblEmployees", acFormatXLS, "", , , "Employee List", "For your review.", False
End Sub


Related examples in the same category

1.Send email for all records in an Access table
2.Send email by Using POP3
3.Display the information in a list of mails
4.Searching for Items
5.Adds an addressee, a subject, and body text; applies the HTML format; sets the importance to high; and sends the message:
6.Sending a Message
7.Using the CreateItem Method to Create Default Items
8.Send out an email by using the DoCmd.SendObject