Automatically Print Exchange Email Attachment?

[Guest]

I would like to automatically print MS Exchange email attachments when a form
is opened. Here's what we have:

- An Access 2002 DB that I'm creating for the Finance team to
easily/quickly enter sales orders into our financial database.

- We have a company policy where all Sales Orders must have a faxed copy of
the PO.

- A Microsoft Exchange 2000 email server with FAX recieiving capability.
I've created a public folder called "PONUMBERS" on the Exchange Server and
ALL POs associated with sales orders will placed in this public folder.

- Here's the link between Access DB and Exchange: The SUBJECT LINE of each
email will have the SALES ORDER number.

- All Faxes are converted to emails and contain an attachment in .TIF
format (that is the actual fax).

The Finance team will be reviewing all Sales Orders against the PO Number.
I will generate a form (via a query) that will display each sales order to be
reviewed and would like to automatically print out EVERY PO (email
attachment) when the form is opened.

Possible?

Any help is greatly appreciate. Thanks in advance for your assistance.

Gary

 

[Rob Oldfield]

It's not something that I've ever really played with, but you should be able
to control it via Outlook automation. This...

http://www.serverwatch.com/tutorials/article.php/1474711

(though you'll need a reference to an Outlook object model....why does
everyone always assume this is obvious and not bother mentioning it?)

.... looks like a good place to start, but a Google for "Outlook automation"
should get you going.