PocketPC Category Remover COM Add-in for Outlook
Click to download:
The VB Script
The ZIP file of the COM add-in setup.exe file.
NB: These are provided AS IS with no warranty and no support.
Newsflash! (February 12, 2004): Microsoft publishes KnowledgeBase article entitled Calendar items show incorrect date and time on your Pocket PC device.
For Pocket PC users we’ve encountered problems exporting calendar entries with certain types of category keywords. We’ve written a VB script and COM add-in to fix the problem.
In the course of migrating legacy Meeting Maker data into Exchange 2000, Sumatra adds a keyword as a category to all email and calendar objects. Categories allow Outlook users to identify new email and calendar entries, and gives Sumatra a simple way to gracefully back out of an Exchange data migration if something goes wrong.
A few weeks after a successful data migration, the client contacted us to discuss some unusual calendar behavior. Calendar entries on the Pocket PC that were tagged with the Sumatra migration keyword (which for the purposes of discussion is “mmconv102659080356Z”) were not being displayed properly. Our research confirmed the Pocket PC calendar import via ActiveSync has problems with categories.
Since the category to support the migration was added under program control into all calendars, it was easy to programmatically remove it in all users’ calendars. The customer wondered if this tool could be applied to remove all categories. Although this helps the Pocket PC users, it penalizes the rest of the organization who use categories.
We know we aren’t the only people who’ve run into this problem, so we’ve produced the following Visual Basic script for an individual Outlook user to remove any keyword which has been found to cause a problem from all messages and calendar entries.
It prompts to allow a single user to remove a single category keyword or all keywords from their Calendar and Inbox data. Please note the following restrictions:
- The only works on the Inbox and the Calendar (not Tasks, Contacts, or other mail folders)
- This has no “UNDO” function. If you remove a category you don’t want removed you’ll need to add it manually
- Because of the way Exchange works, if this user is guest at a meeting which the meeting owner has added a category tag to AND the meeting is updated, the category label will again be added
Basic Scripts (VBA) in Outlook does have some restrictions:
- Users can modify VBA code unless the project is password-protected. (This can introduce support problems when users start to modify the code.)
- There is no simple way to distribute Outlook VBA code to users. Outlook supports one VBA project at a time. The successful implementation of the VBA script depends on the users to open the Visual Basic Editor and import the modules. An alternative would be to distribute an entire project file to users, but that would mean that any previous modifications to a user's project would be lost. If the user has existing code, they must export the code to one or more module files before loading this VBA project, or the current project will be over-written. That said, you can send this script around to the users who experience problems with the Pocket PCs, along with these instructions how to implement the macro.
Copy the script.
Go to Tools-Macro-Visual Basic Editor.
Insert-Module and Paste the script in, OR, if you’ve chosen to download the code stored in the file “module1.bas”, you can File-Import File-Module1.bas
Save it, give it a name, and execute from the Macro function
- Users who import code modules written by others will receive a warning message unless they either sign the VBA project or lower their macro security level. This message annoys users, who might lower their macro security level. We caution against this: It exposes users (and potentially your organization) to malicious VBScript embedded in messages.
- XP Users who don’t have macro protection set properly will receive this message: The macros in this project are disabled….” Refer to this footnote to change the macro security settings to medium.
Another distribution strategy if this Pocket PC – Category problem impacts many users in your organization is to use a COM add-in. Sumatra has converted this VBA macro into a COM add in. This add-in will work for Outlook 2000, 2002, and 2003. This COM add-in is available on an unsupported basis
 Refer to:
· Microsoft Product Support Services article WD2002: "The Macros in the Project Are Disabled" Message When You Run a Macro (Q290949) to enable the macro to run properly.
· Microsoft assistance article Changing Macro Security Settings in Office XP.
Copyright © 2000-2008 Sumatra Development LLC. All rights reserved.