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

B

Brandy De Shazo

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.
 
R

Rob Parker

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
 
B

Brandy De Shazo

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

Rob Parker

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
 
Top