Printing a Report to Microsoft Office Document Image Writer

D

Dan Keaton

I have hundreds of reports to send to about 50 email recipients and this
process repeats every 15 days.

I have automated the process by using "SendObject" to create the report in
"Snapshot Viewer" format, and emailling it to the recipients.

However, I have now been requested to send the reports in "Microsoft Office
Document Image Writer" format (".mdi").

My problem is that while I can manually create a report by printing it to
"Microsoft Office Document Image Writer" printer, I can not find a way to
automate the process using acceptable programming practices.

Specificially, if I set the default printer to "Microsoft Office Document
Image Writer" printer, then when I print, it opens a dialog box for me to
manually specify a full path and filename for the output file.

I want to be able to, within Microsoft Access (within VBA) to specify the
full path and filename, so the user does not have to manually type the
information.

Is there a way to accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with printing a word document containing a table 0
Office Word JPEG in a document showing but not printing out 0
How to center adjust text above and image in a two column document. 1
Write a report to Microsoft Office Document Image Writer using VBA 2
Error outlook.com 0xc0000005 trying to open custom controls 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Print macro using Microsoft Office Document Image Writer 4
cannot print using document image writer 1

Top