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

Automatic assigning of categories



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 6th 10, 11:34 PM
peterkronenberg peterkronenberg is offline
Junior Member
 
First recorded activity at Outlookbanter: Jul 2010
Posts: 1
Default Automatic assigning of categories

I want to be able to assign categories to Outlook (2003) appointments based on a keyword search of the title. For example, "Business: Lunch with client" or "Personal: doctor's appointment". This is a simplistic example, but you get the idea. I am importing data from another application (Maximizer) and I want the appointments to be assigned to a category, Business or Personal in this example, based on the title of the appointment.
Outlook has a way of programatically setting the label or color, but I don't see any way to do the same for category.

I've managed to figure out how to write a simple macro, using the ItemAdd event, to do exactly what I want when an appointment is entered manually. But it does not work with whatever process Maximizer is using to send the data over. The help says "This event does not run when a large number of items are added to the folder at once". I'm not sure if this is my problem or not. "Large" must be a relative term, because I'm not adding more than a few dozen items. However, clearly it must mean some sort of bulk process.

If I can't have my macro called every time an appointment is added, then I wrote a macro to simply go through all the appointments and modify them. But I want to know when to call the macro. It would be wasteful to simply call it every n minutes. I have no idea how Maximizer is doing its synchronization. Outlook doesn't have to be up. But is there some other trigger I can use? There must be some way that Maximizer is establishing a connection and presumably a point at which the connection is broken. Is there a way I can use that as a trigger so that my macro can run as soon as Maximizer is finished updating?
Ads
 




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
assigning categories to email in outlook 2007 chris Outlook - General Queries 2 December 8th 09 08:10 PM
assigning categories automatically when from distribution groups glennindc Outlook - General Queries 0 August 14th 09 03:34 PM
Programmatically assigning categories Jody Outlook and VBA 2 June 17th 08 03:45 AM
Distribution List Automatic Updating by Categories Kicookie Outlook - Using Contacts 1 September 24th 07 11:30 PM
Assigning Categories to Emails Keith Brown Outlook and VBA 1 February 15th 06 03:42 PM


All times are GMT +1. The time now is 04:41 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.