Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Forms / May 2004

Tip: Looking for answers? Try searching our database.

How to prevent duplicate info in Custom Field?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MLGLLC - 28 May 2004 21:16 GMT
Hey folks, I'm a noob at programming Outlook.  I am interested in modifying the default contact form in Outlook 2000.  I use Outlook to keep track of clients as well as personal contacts. I would like to create a custom field for clients in which to assign a matter number (e.g. "M001, T012", etc.).  However, I would like prevent the entry of duplicates (no two contacts may have the same matter number).  I would like Outlook to tell me when I have tried to assign a matter number to a contact that is already in use (similar to the default error message that pops up when I have created two contacts with the same names).  I have reviwed a number of manuals and looked around but have not found a solution to my problem.  I assume that I will have to script a solution that checks for duplicates on entry.  Does anyone have any suggestion for how I might go about this? Is there a simpler solution

Thanks in advanc

brad
Sue Mosher [MVP-Outlook] - 29 May 2004 01:27 GMT
You would need to use the MAPIFolder.Items.Find method to check for an
existing contact with the same value in the field you want to search on.

Signature

Sue Mosher, Outlook MVP
Author of
    Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> Hey folks, I'm a noob at programming Outlook.  I am interested in modifying the default contact form in Outlook 2000.  I use Outlook to keep
track of clients as well as personal contacts. I would like to create a
custom field for clients in which to assign a matter number (e.g. "M001,
T012", etc.).  However, I would like prevent the entry of duplicates (no two
contacts may have the same matter number).  I would like Outlook to tell me
when I have tried to assign a matter number to a contact that is already in
use (similar to the default error message that pops up when I have created
two contacts with the same names).  I have reviwed a number of manuals and
looked around but have not found a solution to my problem.  I assume that I
will have to script a solution that checks for duplicates on entry.  Does
anyone have any suggestion for how I might go about this? Is there a simpler
solution?

> Thanks in advance
>
> brad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.