Solved

Identify (in Inbox) whether I am on the To / cc / bcc list.

Posted on 2004-04-29
15
406 Views
Last Modified: 2013-12-18

How would I go about identifying this - is it a feature in 6.5+ or something, or should I use designer to include a column which detects this and shows an icon or something?  If it is the latter - please give pointers on the formula to use.
0
Comment
Question by:Macavity12345
  • 7
  • 4
  • 3
  • +1
15 Comments
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
yeah. u need to modify mail template to do this. Create 3 columns and for each column give th respective field names. as
SendTo ,CopyTo, BlindCopyTo


0
 

Author Comment

by:Macavity12345
Comment Utility
That would give me three columns with a lot of stuff in each.  I just want an indication whether I am in to, cc, or bcc.

So I was thinking more along the lines of one column, with
@if(I am in to; icon1; I am in cc; icon2; icon3)
kind of thing.

Complication is "I" could be part of a group, which is in to: etc.
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
Ok, no problem.

create a column and in the column properties, enable display as icons.

and in the formula:
U can change the no's upto 99 for icons.
@If(SendTo<>"";55;CopyTo<>"";56;57)
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
u can see help for icon no's.

the above code will work and hope ur asking some thing like that.
0
 

Author Comment

by:Macavity12345
Comment Utility
The code will give value 55 as long as SendTo is not empty - which is practically always.  Just checking whether the field is empty does not work.  

I need some way to check if the mail is addressed to ME in to, cc or bcc.  i.e., "I" or "Username" is a member of SendTo, ...  Problem is the mail can be addressed to me from Notes or Internet, or could be addressed to a group I belong to etc.  
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
somewhat tricky.
But I need send time. and it can be done. You can have hope.
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
sorry. it is Some time
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Macavity12345
Comment Utility
So far here is what I have for the hidden column:

tempName := @Name([CN]; @UserName);
tempName := "*" + @ReplaceSubstring(tempName; " "; "*") + "*";
@If(@Matches(SendTo; tempName); 148; @Matches(CopyTo; tempName); 159; 0)

This works for me, and some others, as most of our internet email ids are FirstName.LastName@..., however it does not work for groups, and for those people whose middle names are in CN.
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
looking good.
0
 
LVL 19

Expert Comment

by:madheeswar
Comment Utility
I suspect the performance will be very slow. Since ur using @username in views.
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 500 total points
Comment Utility
If you have 6.0x or 6.5x, just use the OpenNTF Mail Experience template.  It includes an indicator to show how you were designated recipient.
0
 
LVL 14

Expert Comment

by:p_partha
Comment Utility
@username if used in view column formulas gives unpredictable results,. It can be used "shared, private on first use"
0
 

Author Comment

by:Macavity12345
Comment Utility
Checked the OpenNTF template - uses DbfTitle, which is OK, and modified the internet address conditions.  Works fine.  While I probably wont use the entire template, (some things dont seem to be working right), this column was useful. Thanks.
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
If something doesn't work right in the template, let me know!  We'll get it fixed in a jiffy!

or, you can correct it and post the correction for template inclusion.
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
Any progress?
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

743 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

18 Experts available now in Live!

Get 1:1 Help Now