A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Comparing email address with contacts



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old October 18th 07, 05:51 PM posted to microsoft.public.outlook.program_vba
Patrick Pirtle
external usenet poster
 
Posts: 14
Default Comparing email address with contacts

I'm using an app that redirects incoming emails to
different folders based upon categories assigned in
my contacts I use the lines:

strAddress = oSafeMail.Sender.Address
For i = 1 To 3
strFind = "[Email" & i & "Address] = """ & strAddress & """ and
[FileAs] ""Group"""
Set oContact = allContacts.Find(strFind)

to loop through my contacts looking for the sender.

My problem is that, on occasion, this fails to find the
person in my contacts even though they're in there.
When I start trying to debug the problem, I start
getting confused as to just what is being compared.



For example, I might have a contact with:

Email... = "
Display as: "Susan M.Johnson P.E. )"

I receive an email from her, and it displays in my inbox
as being from "Susan M. Johnson". If I open the email,
the From field contains "Susan M. Johnson". If I
try to look at the header through the View\Options menu,
it doesn't show any header at all, as this came through
the Exchange Server.

The search string my app builds looks like:
"[Email1Address] = "/O=COMPANY/OU=FIRST ADMINISTRATIVE
GROUP/CN=RECIPIENTS/CN=SMJ" and [FileAs] "Group""

I assume the "SMJ" above is because her email is
actually stored as and Exchange
has "Susan M. Johnson" as some kind of alias.(?)

My app correctly moves this one to the correct folder.




Now, I have another contact with:

Email... = "
Display as: "

I receive an email from him, and it displays in my inbox
as being from "Rick Jones". If I open the email email, the
From field contains "Rick Jones ]".
If I look at the header through the View\Options menu,
it shows it to be from "Rick Jones ".

The search string my app builds looks like:

"[Email1Address] = and [FileAs] "Group""

My app correctly moves this one to the correct folder.




And finally, I have a contact with:

Email... = "
Display as: "Paul A Smith P.E. )"

I receive an email from him VIA BLACKBERRY, and it
displays in my inbox as being from "Paul Smith". If I open
the email, the From field contains "Paul Smith ]".
If I try to look at the header through the View\Options menu,
it shows it to be from:

"=?utf-8?B?QnJhZCBDYW1lcm9u?=" "

The search string it is building looks like:

"[Email1Address] = and [FileAs] "Group""

My app FAILS to find this person in my contacts.




I've tried modifying my contact's "Email...", "Display as:",
etc. every which way I could, but can't quite figure out what
is *really* being compared. Is there a better way to search
for these? TIA for any help and suggestions.
____________________________________________
The impossible just takes a little longer...


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
i want 2 know Storing of resume in database and comparing it with the other sriram Outlook - Using Contacts 1 September 11th 07 01:32 PM
Inserting contacts email address to send when forwarding email. NeliRosi Outlook - General Queries 3 August 10th 06 09:54 PM
Comparing 2 MSG files . peketi Outlook and VBA 7 February 17th 06 05:51 AM
Outlook 2002 Uses email address not in Contacts or Address book Pagen Outlook - Using Contacts 1 February 1st 06 05:11 PM
Set which local email account can send mail to contacts in address book. (associating an email address with a contact) Scott Streit Outlook - General Queries 3 January 27th 06 02:57 PM


All times are GMT +1. The time now is 05:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.