Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    10

    Question Unanswered: SendObject for 16,000 + records

    I'm a newbie at Access VBA so please bear with me.

    I'm trying to send a table resulting from a query as an Excel attachment. I'm using the SendObject method and works fine until the records it's sending is more than 16,000 records (which I think is the limit for Excel 95). I'm currently running on Access 97.

    Why does the attachment get sent in Excel 95 format when I'm running Excel 97? Is there any way to make it send in 97 format?

    Thanks

  2. #2
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    not sure about version control but try exporting as a cvs....all versions of access can open it and I don't think there are limitations as it is basically a custom deliminated text file.

  3. #3
    Join Date
    Nov 2002
    Posts
    10
    Does SendObject have an option of attaching in CSV format? I'm running Access97.

Posting Permissions

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