error message sending mail

[ransg]

this works:
DoCmd.SendObject acReport, "RPT_RADI1", "SnapshotFormat(*.snp)", "USFME", "VHERO", "", pbsuject3 & "- RADI tot EVVD", strcontents, True

when I add this piece of code:
DoCmd.SendObject acSpreadsheetTypeExcel9, "j:\john\radi\test", "acFormatXLS(.xls)", ulle@sky.com, "", "", pbsuject3 & "", strcontents, True

I got the error meesage:
The comand or action Output to isn't available now.
Can anyone help?

 

[pbaldy]

If you're trying to send an existing spreadsheet, you'll need to use automation instead of SendObject (presuming you're using Outlook). Search here on "Outlook automation".