I currently have this code
ssql = "EXEC SelectexportReport @Datefrom='" & Me.txt_datefrom & "', @dateto='" & Me.txt_dateto & "'"
Dim rs As New ADODB.Recordset
rs.Open ssql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
And i want to be able to send RS through email like you can with a table using the code
DoCmd.SendObject acSendTable, , acFormatXLS, "dan.james@***co.uk", , , "Employee List", "For your review.",False
However i get an error when using the record set, i have also tried ACSendquery instead of sendtable with no success