Write a report to Microsoft Office Document Image Writer using VBA

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

 

[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.

 

[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.