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






  1. VBA / Excel / Access / Word
  2. Outlook
  3. Email

Send a table through email

 

Sub TestSendObject()
    DoCmd.SendObject acSendTable, "tblEmployees", acFormatXLS, "someone@yahoo.com", , , "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