Re: Automating import of XML files received in Outlook

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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

On Tue, 15 Nov 2005 10:50:10 GMT, "Mus' via AccessMonster.com"
<u11419@uwe> wrote:

>
>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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.

.


Quantcast