By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Exporting a Report As a Word Document

P: n/a
Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
You can export an Access report as a Snapshot file (.snp). This retains all
formatting.
Everybody with Office XP and above has the Snapshot Viewer needed to view
the file.
If you don't have the viewer, it can be downloaded free from Microsoft.
The Snapshot Viewer allows the recipient to view and print, but not edit the
report.

Regards, Greg in Detroit

"feck" <ne*********@hotmail.com> wrote in message
news:8v********************************@4ax.com...
Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN

Nov 13 '05 #2

P: n/a
On Sat, 12 Feb 2005 16:26:04 GMT, "Greg in Detroit"
<re**************@yahoo.com> wrote:

Thanks for info Greg, unfortunately our organisation is not XP'ed up
at this time so would not be a solution at this time.
JBN
You can export an Access report as a Snapshot file (.snp). This retains all
formatting.
Everybody with Office XP and above has the Snapshot Viewer needed to view
the file.
If you don't have the viewer, it can be downloaded free from Microsoft.
The Snapshot Viewer allows the recipient to view and print, but not edit the
report.

Regards, Greg in Detroit

"feck" <ne*********@hotmail.com> wrote in message
news:8v********************************@4ax.com.. .
Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN


Nov 13 '05 #3

P: n/a
Stephen Lebans has a a utility to output to an rtf that retains all the
formating. Unfortunately (though hugely impressively) it's all done
with images. This makes it look great on screen and when printed but
just about impossible to edit. You can check that out at
http://www.lebans.com/ReportUtilities.htm.

Jeremy Wallace

Nov 13 '05 #4

P: n/a
Your options are export to a Word template and tweak when necessary or save
the report as a PDF document and email the PDF document.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"feck" <ne*********@hotmail.com> wrote in message
news:8v********************************@4ax.com...
Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN

Nov 13 '05 #5

P: n/a
You could export to RTF and then run a macro within Word to replace the
different fonts you've chosen in the report into Word Styles.

Rgds

GaryB

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.