I'm new to VB in Outlook and would appreciate some direction. I have a public folder database the uses a custom form based on the calendar form. Users of the database are using either Outlook 2007/Outlook
The database includes 4 fields Type and TypeA (both alpha-num)and Num and NumA (both numeric)
What I'm trying to accomplish would be to have a toolbar button for the manager (not the users) of this folder that when pressed would copy the values of Type to TypeA and Num to NumA for every record in the database. This would allow TypeA and NumA to
remain static (a "snapshot") while Type and Num could change as users change records.
As an aside, if at the same time I could have it delete the contents of 2 fields for all the records in a database(Set1 and Cost) that would be very helpful.
Is this possible?
Thanks in advance for any assistance that can be given!
Those custom fields will be accessible in every AppointmentItem object as a UserProperty object in the AppointmentItem.UserProperties collection. Use UserProperties.Find("TypeA", True) to get each UserProperty object for each custom field, and set UserProperty.Value
to the value you want.
To get all appointments in the Calendar, you need to get a reference to the Folder object. One way is this: