Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    61

    Question Unanswered: Send E-mail in MDB format from a macro or VB.

    I want to send a specific table in my database to a person by e-mail. The problem is that The person I am sending the table to needs it in MDB format which is not available in the sendobject clause of a macro. I used to do this with the program MDB2Email (runapp ...) but since we upgraded to XP this doesn't work anymore (it can't handle access xp).

    Is there another way?? Either in VB or a macro. I haven't found it!

    and of course i don't want to import the table in another database which is just a workaround
    Nobody dies a virgin because life screws us all!

  2. #2
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91

    Re: Send E-mail in MDB format from a macro or VB.

    Is there a problem if you attach the mdb file to your e-mail ?
    My environment: Windows XP/ Access 2000 - Using Microsoft DAO 3.6 Library

  3. #3
    Join Date
    Oct 2003
    Posts
    61

    Re: Send E-mail in MDB format from a macro or VB.

    Originally posted by Mixirica
    Is there a problem if you attach the mdb file to your e-mail ?
    What i want is to send the table through a macro to an enduser. I don't want to send the whole database since it's 30 MB
    Nobody dies a virgin because life screws us all!

  4. #4
    Join Date
    Aug 2003
    Location
    Belgrade
    Posts
    68

    Re: Send E-mail in MDB format from a macro or VB.

    Create an "export" database just for the table you want to send, export the table, and then send the .MDB file as attachment. If you need to do the same operation on a regular basis, you might consider replicating the table into the "export" database.

Posting Permissions

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