Solved

Custom Outlook Contacts fields and Search options

Posted on 2006-07-14
8
313 Views
Last Modified: 2010-04-08
Hi,

I have a need to create a list of contacts with custom fields. Say, it is a list of subcontractors and custom fields would be their specialty (electrical, concrete, etc.), License number and a few others.

Now, I am thinking that the way to do it would be to create a custom contacts form with those fields.

The question is how to do a convinient search based on those fields and also some standard fields. The Outlook "Find" button from the toolbar is very limited and Ctrl-Shift-F Advanced Find is too "advanced" for my users. Is there a middle ground solution a third-party add-in maybe?

Thank you,

Alex.
0
Comment
Question by:alex-n-bill
  • 5
  • 3
8 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 17114505
Hi alex-n-bill,

A custom contact form sounds like a good solution.  I'd recommend a pulldown for the specialty, unless there's a need to track multiple specialties for each contractor.  If, so then checkboxes would make more sense.  The search can be accomplished via a custom search form.  I'm not aware of a third-party utility that does this, but there's an excellent list of third-party add-ins at Slipstick.com (http://slipstick.com).

Cheers!
0
 

Author Comment

by:alex-n-bill
ID: 17123384
Thanks for the idea. But could you please be a little more specific about custom search form creation?
0
 
LVL 76

Expert Comment

by:David Lee
ID: 17123909
alex-n-bill,

Outlook 2002 and beyond has the ability to create user forms.  A user form is a custom dialog-box.  You could create a custom search dialog-box that would invoke a search in the background.  All that's required is building the form (pretty simple) and writing the script (VBA code) to invoke the search.  
0
 

Author Comment

by:alex-n-bill
ID: 17125906
I created my new contact form. What about the search form -- do I create it from form design or from Visual Basic Editor?

Can you send me to some article or some info about how exactly to do it. Especially in regards to VBA code.

Thanks.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 17126080
You'll create the search form in the VB Editor as a userform.  Before creating it you need to decide what fields you plan to search on and whether you'll be searching for single or multiple values in a given field.  Having decide that you can go ahead and build the form, and work out how to construct a search.  If you decide to search fields for a single value, then you have an "and" type search.  Get all records where FieldA="somevalue" And FieldB="somevalue", etc.  If you decide to search any field for multiple values, then you have a mixed search.  Get all records where FieldA="somevalue" And (FieldB="somevalue" Or FieldB="someothervalue").  And type searches are certainly eaiser, both in terms of the search form and the search, but are less useful.  Mixed searches are a bit more comples to put together, but are more useful.  The search itself can be done in several ways.  

1.  Script an advanced search.  Here's a link to a page with samples for that: http://outlookcode.com/search.aspx?text=advanced+search  (The samples are toward the bottom of the page.)

2.  Create a Search Folder on the fly.  I believe this will only work with Outlook 2003.  Here's a link to a previous EE question where I used that approach: http://www.experts-exchange.com/Applications/MS_Office/Outlook/Q_21786890.html

3.  Create a simple search.  This uses the Find or Restrict method of a folder's Items collection to filter out records that don't meet a given set of conditions.  It's the easiest to do, but also the slowest performance wise, and it doesn't give the results back in a display like the other two do.  Typically you use this kind of search behind the scenes to do something, e.g. find all records in a given city and send them all an email.

Outlookcode.com is an excellent resource for scripting/programming Outlook.  I can also recommend a couple of books if you're interested.  
0
 
LVL 76

Expert Comment

by:David Lee
ID: 17220718
Any update, alex-n-bill?
0
 

Author Comment

by:alex-n-bill
ID: 17224059
Yeah, sorry.

I just returned from vacation -- back to my problems. That seemed like a good answer so I am going to give you the points. It will just take me a while to figure out all the details of those artickles and the book (I have Mosher's book on Outlook programming).

Meanwhile I have another question:
http://www.experts-exchange.com/Networking/Email_Groupware/Exchange_Server/Q_21939103.html
0
 
LVL 76

Expert Comment

by:David Lee
ID: 17224104
No problem.  I hope you had a great vacation.  If there'sanything else I can do just let me know.

I'll have a look at the other question.

Cheers!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Join & Write a Comment

Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now