Send Report as Word Document?

  • Thread starter Thread starter Jennifer Crawford
  • Start date Start date
J

Jennifer Crawford

I need to be able to automatically generate a report and
email it to the accounting department.

I can do this by using DoCmd.SendObject, and then sending
the report - which can be sent as an attachment in RTF
format (which seems to be the closest I can get to Word).

However, I've got some special formatting in the report,
where certain lines of the data are bolded (this is set in
the Detail_Format section of the report itself). I can see
this formatting if I preview the report as normal in
Access. However, I cannot see this formatting if I attach
it automatically to an email as an RTF document (or as a
text document, obviously, but it doesn't show if I do it
as an HTML document either).

Alternately, I can dump the entire thing into Excel with
all proper formatting, but once there I have no idea how
to save the file and then attach it to an email
automatically.

A solution to either alternative would be greatly
appreciated - but somehow I've got to be able to
automatically generate an email with the attached report,
with the appropriate formatting included.
 
Jennifer,

Last year, I created a report and created a button on the report to auto
email it to a recipient or group as a Microsoft "Snapshot"
The recipient NEEDS to have Microsoft's "Snapshot Viewer" software which is
free to view the report as it previews.Unfortunately, I would have to go
back and relearn how I did it to be more explicit in my instructions, but
it worked VERY nicely.

Another alternative is to install PDF Writer that comes with Acrobat 6. I
cant remember what the package that came with 5 was called. Distiller, I
think. When it is time to print the doc, choose PDF Writer or distiller as
your printer and voila!, you have a PDF file to email.

Good Luck
Fred Peters
(e-mail address removed)
 
I need to be able to automatically generate a report and
email it to the accounting department.

I can do this by using DoCmd.SendObject, and then sending
the report - which can be sent as an attachment in RTF
format (which seems to be the closest I can get to Word).

However, I've got some special formatting in the report,
where certain lines of the data are bolded (this is set in
the Detail_Format section of the report itself). I can see
this formatting if I preview the report as normal in
Access. However, I cannot see this formatting if I attach
it automatically to an email as an RTF document (or as a
text document, obviously, but it doesn't show if I do it
as an HTML document either).

Alternately, I can dump the entire thing into Excel with
all proper formatting, but once there I have no idea how
to save the file and then attach it to an email
automatically.

A solution to either alternative would be greatly
appreciated - but somehow I've got to be able to
automatically generate an email with the attached report,
with the appropriate formatting included.
Click to expand...

(e-mail address removed)
Jennifer,



Last year, I created a report and created a button on the report to auto
email it to a recipient or group as a Microsoft "Snapshot"

The recipient NEEDS to have Microsoft's "Snapshot Viewer" software which
is free to view the report as it previews. Unfortunately, I would have
to go back and relearn how I did it to be more explicit in my
instructions, but it worked VERY nicely.



Another alternative is to install PDF Writer that comes with Acrobat 6.
I cant remember what the package that came with 5 was called. Distiller,
I think. When it is time to print the doc, choose PDF Writer or
distiller as your printer and voila!, you have a PDF file to email.



Good Luck

Fred Peters

(e-mail address removed)
 
I've had the same issue and recently with Office 2003 discovered Microsoft
Document Image Writer. It's listed as one of my printers and I simply print
to this and will generate an mdi file that opens with Microsoft Office
Document Imaging and can be saved as a tif.

This is the same way that Adobe distiller works from what I recall, but this
is included with Office.
 
Back
Top