Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    emailing a table (Access 2000)

    I have a table in my db that I would like to have the contents of automatically pasted into the body of an email. I have a button on a form the uses the send object command to open outlook. I would like to have the table contents then pasted into the email. If I can't do that is there away to progam it so the table is automaticaly an attachement in the email. Thanks..

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: emailing a table (Access 2000)

    The following will put a table in the body of an e-mail:

    DoCmd.SendObject acSendTable, "tblSomething", acFormatHTML, , , , , , True

    If you change acFormatHTML to acFormatTXT, acFormatRTF or acFormatXLS, the table will be put in an attachment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts