Frontend backend exporting to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I know very little about Access but have converted Tables, Queries to Excel
in the past, however I have run a report from the front end of an Access
database but want to send the results electronically via Excel in an email.
How do I get the report or get to the report to convert it rather than jsut
printing it off? I imagine that if I can get the report in a format that I
can import it to Excel (Get External Data) it should be relatively easy !!
 
Why send it as an excel format? Access has the capability to send the report
as a snapshot of your report. This means that your mail recipients can see
the report exactly as if it were printed and handed to them.
I fthere is a reason for the Excel format, let me know and I will try a
different rout.
 
Back
Top