A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Enhancing filters with VBA - General Question



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 18th 06, 08:43 PM posted to microsoft.public.outlook.program_vba
Martin Mewes
external usenet poster
 
Posts: 1
Default Enhancing filters with VBA - General Question

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
Ads
  #2  
Old March 19th 06, 03:17 PM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Enhancing filters with VBA - General Question

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

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DASL Filters!!!! Radiohead Add-ins for Outlook 2 February 21st 06 02:40 PM
Contact - General tab Mick999 Outlook - Using Contacts 1 February 8th 06 09:26 PM
Task filters should be linked to calendar filters fetch98 Outlook - Calandaring 0 January 19th 06 08:06 PM
Outlook Connector for Domino and VBA question [email protected] Outlook and VBA 0 January 18th 06 08:56 AM
CAnt find microsoft.public.outlookexpress.general ???? ??????? Outlook Express 0 January 8th 06 04:01 AM


All times are GMT +1. The time now is 07:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.