Enhancing filters with VBA - General Question

[Martin Mewes]

Hi all,

this is the status:

Outlook 2003 is connected via IMAP to a remote Exchange (SBS 2000 - not sure
at the moment - can check on demand). While configuring Outlook created two
PST files, one for the account itself which is not used at all and one for
the disconnected IMAP folders.

This is a view on the folders (as good as I can).

Support (local not used)
\ Inbox
\ Send items
\ ...

IMAP (remote and used)
\Inbox
\Send items
\ ...

When the client connects to the server and checks for new messages it does
filter for "Ref.#" and moves all eMails where it can find this as a part of
the subject line into another folder named "eMails with Ref.#"

Now, the user in front of the client needs this filter to be more dynamic
because there are several reference numbers and he needs to have folders
within "eMails with Ref.#" based on the number sequence.

Let me try to say it in simple terms.

a) eMail comes in with "Ref.#" in the subject
b) eMail is moved to "eMails with Ref.#"
c) Lookup the reference number
1. if a subfolder with the number does exist
-> move it there
2. if a subfolder with the number does not exist
-> create the subfolder
-> move it there

My question: Can such things be done with Outlook VBA?
Do you know any code sample or ready code which I can give him?
Do you know any tools which can directly work on IMAP-folders like this?

My knowledge in scripting is little as it comes to Visual Basic in general.
My programming skills are Perl and Bash, and I have already tried to do some
things with Outlook VBA to absolutely no success at all as I am not used to
work with IDEs at all.

Any help is greatly appreciated.


bis dahin / kind regards

Martin Mewes
Microsoft Certified System Administrator: Messaging

--
070-270 - Implementing and Maintaining a Windows XP Professional Computer
070-284 - Implementing and Maintaining a Exchange Server 2003 Environment
070-290 - Implementing and Maintaining a Windows Server 2003 Infrastructure
070-291 - Implementing and Maintaining a Windows Network Infrastructure
070-293 - Designing, Implementing and Maintaining a Windows Network Infrastructure
070-298 - Designing, Implementing and Maintaining Security for a Windows Network Infrastructure

 

[Michael Bauer]

Am Sat, 18 Mar 2006 21:43:35 +0100 schrieb Martin Mewes:

Martin, that can be done with VBA.

You might use the ItemAdd event, which tells you about new items in a
folder. Then you get a substring of the subject by the functions InStr, Len,
Left, Right and/or Mid.