Email a non-Access file

[Guest]

Hi
I've written a macro to export a table to Excel format, and then email it.
When it is opened in Excel, 'Wrap text' is automatically set to ON, which
means the information does not display as it should.
As a result, I've tried TransferSpreadsheet - which works fine, but I don't
know how to get an Access macro to email a non-Access file. If I use
SendObject, it asks for which Access bit to send. Help!

 

[John Nurick]

Hi Andy,

I think you'll need to use VBA to do this rather than a macro. See Tony
Toews's page at http://www.granite.ab.ca/access/email.htm for
information on emailing.