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
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