Help emailing Spreadsheet

[ecugrad]

Need help emailing a spreadsheet.. At the current time I'm just exporting it to a folder using:

DoCmd.TransferSpreadsheet acExport, 5, "Export", "G:\Production\1502Report1.xls", True

Instead of having to go to the folder and attaching to an email, can I have it mailed on a click event or even better on some sort of timer?

Thanks........

 

[Guest_imported]

hi ecugrad

assuming that "export" is the name of the table you've been exporting, try this here code.

DoCmd.SendObject acSendTable, "Export", acFormatXLS, "type email address here", , , "Type Subject here", "Type Message here", False

Hope it works

 

[ecugrad]

Thanks Man...............