Solved

Create a view where items show up in multiple groups

Posted on 2006-11-16
3
147 Views
Last Modified: 2010-04-08
Hello,

I'd like to create a view on a public folder that groups contacts by the Account field.  Easy enough.  But some contacts have multiple account reps.  This means that a contact with "John Doe" as the account rep shows up under the John Doe group, but a contact with "John Doe, Jane Doe" as the account reps doesn't show up in the John Doe group, just the John Doe, Jane Doe group.  I understand why - they appear as unique entries in the account field - but I see the functionality I'm looking for in the built in By Category view, which is also just a field with comma seperated values.

When you click the By Category view each group has only one category listed and if a contact has multiple categories associated, it shows up in each respective group.  Is there a way to do this with other fields (i.e. the Account field)?

Thanks,
Tim

p.s.  I'm using Outlook 2003 and Exchange 2003, if it makes a difference.
0
Comment
Question by:timnorvel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 17962464
Greetings, timnorvel.

The problem is that Account is a text field whereas Categories is a keyword field.  The only way I can see to accomplish what you want is to create a custom form and add your own field, making sure it's a keyword field, for storing the accounts.

Cheers!
0
 

Author Comment

by:timnorvel
ID: 17966718
Thanks BlueDevilFan.  That's the piece I needed - the fact that it's a keywork field.  I am actually in the process of making a custom form for our contacts, so I should be able to do that.

Thanks again,
Tim
0
 
LVL 76

Expert Comment

by:David Lee
ID: 17967307
You're welcome, Tim.  Glad I was able to help out.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

728 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