Can SendObject be used to send an MDB file?

[Gkirkup]

I use SendObject to send automatic emails from my application. Can I attach a table or an MDB file to the email? How do I do that? Or do I attach a table and it sends it as a text file?

Robert

 

[Isskint]

You use SendObject also (intelli sesnse tells you that already see the attached image)


docmd.SendObject(acSendTable,"Table1", ...yadda yadda

 

[Gkirkup]

OK, I have that working, thank you. I see that I have to specify an output format. How do I specify Excel 97? I don't get a drop down list of options.

Robert

 

[Gkirkup]

I see that the output option for Excel is AcFormatXLS. But if I enter that I get the error message "There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access".
There are 17,473 lines in the table. That doesn't seem too much.
The odd thing is, if I leave the output format blank, it prompts for one at run time with a list, and works perfectly. But if I enter AcFormatXLS I get the error message.
It will output AcFormatTXT with no problem, but that is not what I want.
Is there any way that I can output the spreadsheet without having to manually choose the output format at run time?
Robert

 

[Isskint]

I think that would be acFormatXLS