send excel file via access

[SiGill]

Hi guys

I am trying to send an excel file via access, is this possible. I'll explain in full what I am doing.

I am running a query in access. Exporting it to excel. Access then formats it, bolds the headers, etc. I then want Access to e-mail this now formated spreadsheet. Is this possible?

Thanks
Simon

 

[ghudson]

Yes, search the forum for there are plenty examples on how to email a file from Access.