Kevin,
Not sure that I can help, but I'll try.
What kind of file are you sending out, and are you using sp_send_dbmail to do it, or something else?
If using dbmail, are you using the @attach_query_result_as_file option?
Just trying to get a sense of what method you're currently using.
Thanks,
James