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...