Emailing a report as an excel sheet

[Tumby]

I have a report that is made up from a query using three different tables, Customers, Sites and Electricity. The report shows all data correctly but when it is sent as an excel sheet by email the data from Customer table is not showing. The headings are there but no data. What could be the cause of this.
The database is compiled in access 2003 and the excel sheet is 2003 also.

I have another report using the tables Customers, Sites and Gas that shows all the data correctly when emailed as an excel spreadsheet.

 

[apr pillai]

It is better if you try to send the Query contents in Excel Format, if you want to exchange the Data rather than converting Report into Excel format.

Report can be exported into Snapshot Format (file with an .snp extension) and it can be viewed/printed at the target location.