Re: Enhancing filters with VBA - General Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


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
.

Relevant Pages

  • Re: Incoming mails lost in Windows Mail
    ... I found out now how to search the entire folders, in going to Edit - Search ... Please also confirm that the rules and junkmail settings (aswell as all other Windows Mail settings) are also saved before I go ahead. ... imports all your WM accounts, settings, folders and emails. ... I received on another account at work and transfered it to my Windows ...
    (microsoft.public.windows.vista.mail)
  • Re: Incoming mails lost in Windows Mail
    ... I found out now how to search the entire folders, ... other Windows Mail settings) are also saved before I go ahead. ... imports all your WM accounts, settings, folders and emails. ...
    (microsoft.public.windows.vista.mail)
  • Re: Incoming mails lost in Windows Mail
    ... I found out now how to search the entire folders, in going to Edit - Search ... If it turns out that Windows Live Mail doesn't meet your expectations, ... imports all your WM accounts, settings, folders and emails. ... So should I now try removing the mail account, ...
    (microsoft.public.windows.vista.mail)
  • Re: Opening my email in outlook express
    ... can view the emails just fine on that PC. ... "Kuay Tim" wrote: ... It doesn't matter if they were already in my folders or if new ... >> the emails in my folders will not display in the preview window. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Lost links between contacts and email in entourage 2004
    ... > The emails are still there, in the Mail window in whatever subfolder I ... > When people asked me why I use Entourage rather than Apple's suite, ... You can use the filter in mail folders, or the Advanced Find to search ALL ... and importing back in with Messages Import into X script. ...
    (microsoft.public.mac.office.entourage)