How do I send soft copy of Access 97 report with formatting?

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

Guest

My Access reports are nicely formatted and print beautifully. Now my users
want me to email soft copies and I don't know how to do this without dropping
all the formatting and sending plain text.
 
Check out SendObject, and use the Snapshot format. It's the only one which
will retain all the formatting in your report (unless you use a third-party
solution). Or output your report to a .pdf file (this will require that you
have a pdf printer driver installed) and send that file.

Rob
 
Thank you for your quick response. I tried it but was unable to open the snp
file. I was able to add an Adobe printer and print to file which worked
beautifully. I'm sure the snapshot solution also works fine, but my users
would have to have the Snapsot reader to view it. They already have Adobe,
so this solves my problem! Now - on to the other problems!
 
Glad it worked so easily ;-). As an aside, the snapshot viewer is a free
download from Microsoft; it's included with Office XP and 2003 (at least -
possibly also with Office 2000); you might need Custom or Full install to
actually install it on your system.

Rob
 
Back
Top