Macros in Outlook 2003

I have done software developement in the past, but not much in the way of VBA macros. Basically I have two calendars here at work in Outlook 2003 on a desktop computer. One is on exchange server and the other is in a PST file that I take home and back every day.

I have categories setup on both my work computer and my home computer. So when meeting requests come thru my work email they end up in the "other" category in my exchange calendar. I then copy the "other" category items over to my other PST calendar and re-categorize them on both the exchange side and the PST side.

Another category is setup up called "sync". So any calendar item in my PST file that I want displayed in the exchange calendar gets flagged with this "sync" category. At the end of the day I manually delete all items in the exchange calendar and then copy all "sync" items over to the exchange calendar.

This all seems to work fine, but is pretty time consuming.

Basically I want to have two macros:

1) MOVE macro -> when run would search thru the exchange calendar items and look for all items with the "other" category designation. Would then copy those items over to my PST calendar, and at the same time change the category from "other" to "XXXXX" (XXXXX being my company name), and simultaneously adding the "sync" category. Would want the macro to also change the original calendar item from "other" to my "XXXXXX" category on the exchange side.

2) UPDATE macro -> would first go select all calendar items in the exchange calendar and delete them. Then go copy all calendar items from the PST calendar with the "sync" category over to the exchange calendar.

The first macro would always be used when transferring items over to the "main" PST calendar. And would want to be able to run it seperately. When running the 2nd macro, I would want it to always run the first macro first. To make sure all "other" category items are not deleted.

Do I need to go buy a VBA book??? Or can some folks just give me some hints on how to do this .....

Thanks .......

Would also be interested in having some on develop this for me; and I would pay $$$

Edited October 17, 200718 yr by mackconsult