Automating import of XML files received in Outlook

[Mus' via AccessMonster.com]

Hi

I regularly received XML files by email and would like to set up outlook to
automatically import the attached files into my database upon receipt.
Something along the lines of a rule that recognises a certain subject and
then extracts the data in the attached XML file to the designated database.

I've taken a quick look at the Outlook rules and assume I need to select
'script' or 'custom action' but where to I create these and in what format (I
assume VB or Java)??

This a new horizon for me so any guidance appreciated.

Many Thanks

 

[John Nurick]

This is the wrong place to ask about programming Outlook. Take a look at
www.outlookcode.com and www.slipstick.com first, they're great
resources. If they don't have information about creating rules that run
scripts or VBA code, try searching the Outlook newsgroups at
http://groups.google.com, and if that fails ask in an Outlook group.

After that - and assuming that the XML data is in a form that your
version of Access is happy to swallow, which you presumably already know
- the rest should be straightforward Automation. If you need help with
that, post back here when you've got the Outlook side sorted (i.e.
identifying the messages and saving their attachments to disk ready to
import).

 

[Mus']

Thanks John, I predominantly use Access and knowing how helpful this forum is
figured that someone may have addressed this problem before, just looking for
a heads up and your suggest links help.

I'm close to addressing the removal of attachments to a folder, although I am
also considering having the files imported straight in to a folder by ftp.

As you point out, the next challenge I have is in importing these files into
the database and I could do with some help on this code.

Basically, at an onclick event I want Access to go to the 'folder', and
import each file that is in there. The file names will be random so I suspect
I need somethign along the lines of for each 'file' in 'folder' and then an
import instruction. I will then need to automate either the deletion of the
files from the folder or moving them to another folder to reflect that they
have been imported.

P.S. I have now been given the option of receiving these file sin either XML,
CSV, or TXT.

Any help, or pointing in the right direction appreciated.

Hi

[quoted text clipped - 10 lines]

Many Thanks