Write a report to Microsoft Office Document Image Writer using VBA

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?
 
S

SJKlein

Hi Dan;

You can create a macro to do this for you. Hint: "Printout" in the print
to property send it to Microsoft Office Document Image.
 
D

Dan Keaton

Dear Shawn,

Thank you very much.

I assume that you want me to create a Macro with the "Action" being
"Printout".

I do not know what you mean by "Printout" in the print to property.

Could you please elaborate as my "Printout" Macro Action does not have a
"Print To" property. I am using Access 2003.
 

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

Top