Exporting large amounts of data to excel and send them by mail.

R

remco putker

Hello there,

Last week I created a database linked to an export file
from an existing ERP-system. I am using this database to
distribute managementinformation to different divisions.
To export this information I use various ways, e.g.:
reports, complete query's and access-generated emails. I'm
very pleased with te macro function 'SendObject' but
unfortunatly it doesn't seem to work the way I want it to.
It's a great feature to automaticaly send an email with a
converted file attached, but why is it that the macro I've
made is not able to export a query (39333 rows) to excel
and send it? As far as I know Excel can cope with 65536
records.
My workstation has office97 installed; I hope you can help
me with this problem.

Kind regards,
Remco Putker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top