I have a report in Access and I'd like to copy it over to word in exactly the same format so I can email it out.
Or alternatively is there an easy file saving way of emailing Access Reports?
2007-02-13 21:02:18 · 3 answers · asked by Spaceman 2 in Computers & Internet ➔ Programming & Design
The best way to do it would be to install a PDF printer driver. Then you can "print" the report to save it as a PDF, and e-mail that.
There are plenty of free PDF printing tools - a quick Google showed http://www.cutepdf.com as a good example.
2007-02-13 22:55:35 · answer #1 · answered by Daniel R 6 · 0⤊ 0⤋
You can export your Access report to .rtf (Rich Text Format), but unfortunately, some formatting will be lost. Fonts are retained, but drawn objects such as lines are not.
If you are e-mailing to someone who also has Access installed, you should export your report to a .snp (Snapshot) format, which preserves the report layout exactly as it appears in Access. The Snapshot format requires that the recipient have the Snapshot Viewer installed on their PC, which is installed with Microsoft Access.
2007-02-14 14:30:53 · answer #2 · answered by MamaBean 3 · 0⤊ 0⤋
You should be able to email the report from Access rather than copying it into Word. If you really must import it into Word then use OBDC (see Word/Access help files) to import/export the data.
2007-02-14 05:10:03 · answer #3 · answered by Del Piero 10 7 · 0⤊ 0⤋