Hi!
Please, I would like to know if it is possible to export data from Access to an Excel file using

DoCmd.SendObject acSendQuery, "qryName", acFormatXLS, _
        cboRecipient, , , "Subject Line", _
        "Dear " & cboRecipient & ":" & Chr(10) & _
        "Comment to recipient" & _
        Chr(10) & Chr(10) & _
        "Thanks," & _
        Chr(10) & _
        cAuthor

but somehow alter the default of the file exported to Excel, such that the top row of the exported file (the header row) is not shaded grey? I think this must be the default setting when exporting queries. This is a user request...apparently the exported grey top row blends in with Excel's grey columns (A,B,C,etc..) and some of the recipients don't realize the top row is a header. Goofy huh!?! In any case, can anyone help me find a way to make the recipients happier? Any help would be greatly appreciated.

Thank you so much in advance

Could you export it as a CSV? - most people have Excel as the default CSV handler, so they'd see an Excel icon for the file, which should please them.

HTH
Steven

I am a loud man with a very large hat. This means I am in charge

Steven - Hi, thanks for the suggestion. I think that would workout perfectly if only I could do that through the code I used... The code below is how it gets exported to email - and acFormatXLS is the output format. acFormatCSV does not work, acFormatTXT does not work, as the end recipients are not the most computer literate to delimit the txt file.
But I thank you for the suggestion - is it possible that there is some other code I could write that would do what I am trying to accomplish, yet export it as a CSV??

Any help would be very much appreciated,
Sean

DoCmd.SendObject acSendQuery, "qryName", acFormatXLS, _
        cboRecipient, , , "Subject Line", _
        "Dear " & cboRecipient & ":" & Chr(10) & _
        "Comment to recipient" & _
        Chr(10) & Chr(10) & _
        "Thanks," & _
        Chr(10) & _
        cAuthor