Frontend backend exporting to Excel

G

Gerry

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 !!
 
M

Mike

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Office Forms and dynamically updating the excel backend 0
Export Report with Graph to Excel error 2495 1
Export Access Report to Excel keep format 4
2 frontends and 2 backends 0
Need a little advice on frontend - backend set up... again. 1
exporting report fields to spreadsheet 1
Export Access Report to Excel 4
Shutdown error exporting to Excel 1

Top