Form Timer Event

[LKH]

I want to use a form timer event to see if new emails have arrived and it has
an attachement. If it does, then I want to extract the attachment data (a
..X12 file) into a DB. Can anyone help me with how to do this?

 

[pietlinden]

I want to use a form timer event to see if new emails have arrived and ithas
an attachement.  If it does, then I want to extract the attachment data(a
.X12 file) into a DB.  Can anyone help me with how to do this?

use the code here for the inbox watcher then you would loop through
the messages, and then through each message's attachments collection
and save the attachment somewhere.

There are examples of automating outlook on Danny's site too.

 

[Chris O''Neill]

I'm not sure about "Danny" but here's some general info on using automation
in Access to bang away at Outlook:

Http://msdn.microsoft.com/en-us/library/aa159619(office.11).aspx

For searching a default folder, this link will provide some information on
the Find method. (You'll also need to look at FindNext):

http://msdn.microsoft.com/en-us/library/aa220093(office.11).aspx

For info on searching multiple folders, you'll need the AdvancedSearch and
AdvancedSearchComplete methods. This link will provide some guidance:

http://msdn.microsoft.com/en-us/library/aa220071(office.11).aspx

Hope that's helped...

Regards, Chris