Report output options other than RTF

[SJ]

Hi,

Given that the RTF renderer in Access seems to be slightly bust in that it
truncates text, does anyone have any other suggestions as to what output i
could use.

i have tried HTML which would work, apart from the fact that when the output
is long it puts it over two separate pages which is a pain for saving and
storing.

I'm currently using the following code:
DoCmd.SendObject acSendReport,
"rptStudentAssignmentFeedbackDetailsCCtoTutor", "HTML", TutorEmail, , ,
subj, msg, True

Is there a way to output to a .doc format and then automatically attach to
email?

regards
A

 

[Scott McDaniel]

You can save it as a Snapshot format (kind of like a PDF) and send that.
Your recepient will have to have the Snapshot viewer, which is freely
available from MS (google on "ms access snapshot viewer" to find the current
location) but this format will preserve your formatting.

DoCmd.SendObject acSendReport,
"rptStudentAssignmentFeedbackDetailsCCtoTutor", "Snapshot Format (*.snp)",
TutorEmail, , , subj, msg, True

Snapshot Viewer:
http://www.microsoft.com/downloads/...3f-6d74-423d-8274-8b7e6313edfb&displaylang=en

 

[SJ]

Thanks Scott

 

[Mark Andrews]

PDF is the best format to use, snapshot is second, excel probably third and
rtf works for some simple reports.

You could use our products to either batch create pdf files or dynamically
create pdf files from a website.

Or just manually print to a pdf file works as well.

HTH,
Mark
RPT Software
http://www.rptsoftware.com