Using Microsoft Access to create an ".MDI" file

D

Dan Keaton

I am attempting to print or email some reports using VBA within MS Access.

I have not found a way to create an ".MDI" file (automatically using VBA)
from within Access.

Any suggestions would be most welcome.
 
D

Dan Keaton

Dear Bob,

Thank you for your response.

I have hundreds of reports to send to about 50 email recipients.

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

Bob Buckland ?:-\)

Hi Dan,

MS .MDI files are variants of the TIFF graphic file format.
The usual way to create these in Office 2003 or 2007 is to print to the optional install MS Office Document Imaging Writer printer
from the Microsoft Office choice in Add/Remove Programs in the Windows Control Panel.

You may want to follow up in the MS Office Access discussion group using the link below.

============
I am attempting to print or email some reports using VBA within MS Access.

I have not found a way to create an ".MDI" file (automatically using VBA)
from within Access.

Any suggestions would be most welcome.
--
Dan Keaton <<
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
Top