email spreadsheet in html format

[idono]

You know that cool button in Excel 2000 that creates an email as html and sends to persons you specify. Anyone have an idea on how the do it? If you record a macro while doing that you get nothing. Any ideas are appreciated.

Dugger

 

[ajdesalvo]

You can use the SendObject method to send a Report, etc. to someone as a html document. Check it out in the Access Help.

Looks something like this:

DoCmd.SendObject acSendTable, "Employees", acFormatHTML, "Nancy Davolio; Andrew Fuller", "Joan Weber", , "Current Spreadsheet of Employees", , False


Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[idono]

Ok, I didn't explain myself well. I am coding in an Access module that creates an excel spreadsheet and does all the formating. Once that is done I want to send the spreadsheet in html format instead of as an attachment. Just like that button does on the standard menu (Excel). Maybe that will clear up some things. The information isn't in any one table or report it is bits and pieces drawn and calculated from many tables and queries. Anymore ideas?