G Guest Oct 3, 2005 #2 Try this docmd.OutputTo acOutputReport,"ReportName", acFormatXLS,"LocationAndNameOfFile"