Pages

Tuesday, March 18, 2008

Outlook Contact

Add a last contacted date to your Outlook 2002 contacts

I occasionally use the Journal feature in Microsoft Outlook® 2002 to associate e-mail messages, meeting items, task items, and Office files with my contacts. I sometimes create individual Journal items and associate them with individual contacts as well. However, sometimes I want to quickly make a note of when I last contacted someone without taking the time to create a complete Journal item. The following steps enable you to quickly make a tick mark that notes when you last spoke with or sent e-mail to one of your Outlook contacts.

To create a macro to add a last contacted date to an Outlook 2002 contact

  1. From inside Outlook, open the Microsoft Office Visual Basic® Editor. (On the Tools menu, point to Macro, and then click Visual Basic Editor.)
  2. If the Project Explorer window is not visible, on the View menu, click Project Explorer.
  3. In the Project Explorer window, expand the folder tree to open the Microsoft Outlook Objects folder, and then double-click ThisOutlookSession.
  4. Type the following code into the Code window (the large, blank window on the right side of the screen):
  5. On the File menu, click Close and Return to Microsoft Outlook.

To run the macro

  1. Open your Outlook Contacts folder.
  2. Select a single contact item (do not open the contact item).
  3. On the Tools menu, point to Macro, and then click Macros.
  4. Click LastContacted, and then click Run.
  5. Click OK when the dialog box appears.
  6. Open the selected Outlook contact item.
  7. On the All Fields tab, in the Select from list, click User-defined fields in this item.

The Last Contacted field appears along with the date and time you ran the LastContacted macro. Be sure to run this macro at or near the time you make your call or send e-mail, so that the date and time entered by the macro are correct.

If you're willing to learn a little more about how this macro functions technically, you can modify it to create additional user-defined fields. For more information, see these resources on the Microsoft Developer Network (MSDN):

  • Item Properties Collection
  • Add Method (Click the Add method as it applies to the ItemProperties object entry on the page to display the details.)

Source Microsoft.office.com

No comments: