Report Formatting

[Gaffer]

I have tried exporting a report to Excel for the purposes of emailing it, but it loses all of it's formatting and generally ends up looking pretty horrible. Can anybody suggest a better way of getting my data out of Access, and looking pretty..?

 

[Ann M]

Did you try just copying and pasting it?? It might be worth a try ... to see if it works.

 

[Gaffer]

I have to keep it as automated as possible, and have to generate several different reports for emailing to different locations. Cut and paste just won't cut it (no pun intended!)

 

[Neal]

Access is really bad at exporting reports in other formats. I have found two things that work: PDFs and Snapshot. You need to buy Adobe Acrobat to use the former. And your users need to have the Snapshot viewer installed (free from Microsoft) if you go with the latter.

 

[Former]

If you create a form, with a button on it you should be able to use the Docmd.SendObject from the button and e-mail the report directly, without having to move it to excel first.