Display recipient's e-mail address in Outlook Inbox

T

TJG

We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
TJG said:
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

Russ Valentine said:
That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
TJG said:
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is (e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
E

Eric Legault [MVP - Outlook]

The sender's e-mail address is not available through any of the built-in
Outlook fields you can use in a view. You can access that address via VBA,
using something like the macro below to display the address for the currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
TJG said:
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

Russ Valentine said:
That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is (e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
M

Michael Bauer

Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


Eric Legault said:
The sender's e-mail address is not available through any of the built-in
Outlook fields you can use in a view. You can access that address via VBA,
using something like the macro below to display the address for the currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
TJG said:
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is (e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
T

TJG

Thanks for that guys. As Eric Legault says, there is no Outlook field which
shows you the email address and you need VBA to extract the email address. I
am currently working on the macro which Eric Legault suggested but Outlook
doesn't like the second line "MsgBox ActiveExplorer.Selection.Item
1).SenderEmailAddress". I'll keep you posted.



Michael Bauer said:
Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


Eric Legault said:
The sender's e-mail address is not available through any of the built-in
Outlook fields you can use in a view. You can access that address via VBA,
using something like the macro below to display the address for the currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is (e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
T

TJG

I have had another look at your suggestion.The information I want to display
in the Inbox is in properties but there seems no way of including it in a
field, other than VBasic.

Michael Bauer said:
Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


Eric Legault said:
The sender's e-mail address is not available through any of the built-in
Outlook fields you can use in a view. You can access that address via VBA,
using something like the macro below to display the address for the currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is (e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
E

Eric Legault [MVP - Outlook]

Sure, you could do that, but it would involve hooking into the ItemAdd event
and adding that field to all incoming messages. This might be too complex
for what its worth.

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

Michael Bauer said:
Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


Eric Legault said:
The sender's e-mail address is not available through any of the built-in
Outlook fields you can use in a view. You can access that address via VBA,
using something like the macro below to display the address for the currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is (e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
E

Eric Legault [MVP - Outlook]

I wonder if your problem is because nothing is selected? I've amended the
code to handle that situation. If you have further problems, try setting
breakpoints in the editor to see what is going on.

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Count = 0 Then Exit Sub
If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
Thanks for that guys. As Eric Legault says, there is no Outlook field which
shows you the email address and you need VBA to extract the email address. I
am currently working on the macro which Eric Legault suggested but Outlook
doesn't like the second line "MsgBox ActiveExplorer.Selection.Item
1).SenderEmailAddress". I'll keep you posted.



Michael Bauer said:
Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


Eric Legault said:
The sender's e-mail address is not available through any of the built-in
Outlook fields you can use in a view. You can access that address via VBA,
using something like the macro below to display the address for the currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

:

We use Outlook 2002 and WindowsXP. I have tried to find the answer to this
problem in the OUTLOOK GENERAL Group and Russ Valentine [MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in the Inbox)
as going to MrsA but when you check the actual receiving email address it is
(e-mail address removed). Of course, if we open an e-mail, right click the to-field
and click on properties, Outlook gives us the recipient's email address. Is
there any way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create a new
field using the [E-mail Account] field and the Iff command but have been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the to-field
and
click on properties, Outlook gives me the recipient's email address. Is
there
really no way to extract this information and display it in the Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check the
actual
receiving email address it is (e-mail address removed). We need to know who
received
the email, i.e. the receiving email address. I have tried the create a
field
using the [E-mail Account]field and the Iff command but have been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display recepient's email
address,
instead of the name, in the TO field in Outlook? The problem we have
it
that
we receive e-mails which say they are addressed to Test Example (who
works
for us and whose e-mail address is
(e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the firm. I
have
tried
to create my own field and use the Iff function and the [E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
D

Dmitry Streblechenko \(MVP\)

Also note that SenderEmailAddress property is only availabel in Outlook
2003.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool


Eric Legault said:
I wonder if your problem is because nothing is selected? I've amended the
code to handle that situation. If you have further problems, try setting
breakpoints in the editor to see what is going on.

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Count = 0 Then Exit Sub
If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
Thanks for that guys. As Eric Legault says, there is no Outlook field which
shows you the email address and you need VBA to extract the email address. I
am currently working on the macro which Eric Legault suggested but Outlook
doesn't like the second line "MsgBox ActiveExplorer.Selection.Item
1).SenderEmailAddress". I'll keep you posted.



Michael Bauer said:
Hi Eric,

wouldn?t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Gru?e
Michael Bauer


message The sender's e-mail address is not available through any of the
built-in
Outlook fields you can use in a view. You can access that address via
VBA,
using something like the macro below to display the address for the
currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

:

We use Outlook 2002 and WindowsXP. I have tried to find the answer
to this
problem in the OUTLOOK GENERAL Group and Russ Valentine
[MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our
correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in
the Inbox)
as going to MrsA but when you check the actual receiving email
address it is
(e-mail address removed). Of course, if we open an e-mail, right click the
to-field
and click on properties, Outlook gives us the recipient's email
address. Is
there any way to extract this information and display it in the
Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create
a new
field using the [E-mail Account] field and the Iff command but have
been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the
to-field
and
click on properties, Outlook gives me the recipient's email
address. Is
there
really no way to extract this information and display it in the
Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of
staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get
is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check
the
actual
receiving email address it is (e-mail address removed). We need to know
who
received
the email, i.e. the receiving email address. I have tried the
create a
field
using the [E-mail Account]field and the Iff command but have
been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display
recepient's email
address,
instead of the name, in the TO field in Outlook? The problem
we have
it
that
we receive e-mails which say they are addressed to Test
Example (who
works
for us and whose e-mail address is
(e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the
firm. I
have
tried
to create my own field and use the Iff function and the
[E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
M

Michael Bauer

As Eric Legault says, there is no Outlook field which
shows you the email address and you need VBA to extract the email
address.

Well, VBA is a main issue of this NG :)
 
M

Michael Bauer

Hi Eric,
I wonder if your problem is because nothing is selected?

that would raise the error in the first line already. I think it´s
because he´s using OL 2002. AFAIK there is no SenderEMailAddress
property.

--
Viele Grüße
Michael Bauer


Eric Legault said:
I wonder if your problem is because nothing is selected? I've amended the
code to handle that situation. If you have further problems, try setting
breakpoints in the editor to see what is going on.

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Count = 0 Then Exit Sub
If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
Thanks for that guys. As Eric Legault says, there is no Outlook field which
shows you the email address and you need VBA to extract the email address. I
am currently working on the macro which Eric Legault suggested but Outlook
doesn't like the second line "MsgBox ActiveExplorer.Selection.Item
1).SenderEmailAddress". I'll keep you posted.



Michael Bauer said:
Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


message The sender's e-mail address is not available through any of the
built-in
Outlook fields you can use in a view. You can access that address via
VBA,
using something like the macro below to display the address for the
currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

:

We use Outlook 2002 and WindowsXP. I have tried to find the answer
to this
problem in the OUTLOOK GENERAL Group and Russ Valentine
[MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our
correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in
the Inbox)
as going to MrsA but when you check the actual receiving email
address it is
(e-mail address removed). Of course, if we open an e-mail, right click the
to-field
and click on properties, Outlook gives us the recipient's email
address. Is
there any way to extract this information and display it in the
Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create
a new
field using the [E-mail Account] field and the Iff command but have
been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the
to-field
and
click on properties, Outlook gives me the recipient's email
address. Is
there
really no way to extract this information and display it in the
Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of
staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get
is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check
the
actual
receiving email address it is (e-mail address removed). We need to know
who
received
the email, i.e. the receiving email address. I have tried the
create a
field
using the [E-mail Account]field and the Iff command but have
been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display
recepient's email
address,
instead of the name, in the TO field in Outlook? The problem
we have
it
that
we receive e-mails which say they are addressed to Test
Example (who
works
for us and whose e-mail address is
(e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the
firm. I
have
tried
to create my own field and use the Iff function and the
[E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 
T

TJG

Hi guys. I am using Outlook2002 which explains the error in line 2 of Eric's
code. I mentioned this in one of my emails to the Outlook General group and
now realize I should have pointed it out again, sorry. If it is not possible
to display the recipient's email address in Outlook2002, I will probably
install Outlook 2003 as I need to get this solved.

Michael Bauer said:
Hi Eric,
I wonder if your problem is because nothing is selected?

that would raise the error in the first line already. I think it´s
because he´s using OL 2002. AFAIK there is no SenderEMailAddress
property.

--
Viele Grüße
Michael Bauer


Eric Legault said:
I wonder if your problem is because nothing is selected? I've amended the
code to handle that situation. If you have further problems, try setting
breakpoints in the editor to see what is going on.

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Count = 0 Then Exit Sub
If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

TJG said:
Thanks for that guys. As Eric Legault says, there is no Outlook field which
shows you the email address and you need VBA to extract the email address. I
am currently working on the macro which Eric Legault suggested but Outlook
doesn't like the second line "MsgBox ActiveExplorer.Selection.Item
1).SenderEmailAddress". I'll keep you posted.



:

Hi Eric,

wouldn´t it be possible to add an UserProperty to each mail with the
e-mail address and then display these field in the view?

--
Viele Grüße
Michael Bauer


message The sender's e-mail address is not available through any of the
built-in
Outlook fields you can use in a view. You can access that address via
VBA,
using something like the macro below to display the address for the
currently
selected e-mail:

Sub ShowSenderEmail()

If ActiveExplorer.Selection.Item(1).Class = olMail Then
MsgBox ActiveExplorer.Selection.Item(1).SenderEmailAddress
End If

End Sub

--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
--------------------------------------------------
{Private e-mails ignored}
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

:

We use Outlook 2002 and WindowsXP. I have tried to find the answer
to this
problem in the OUTLOOK GENERAL Group and Russ Valentine
[MVO-Outlook] has
suggested I ask in a programming group. I have reproduced our
correspondence
so far below. My problem in a nutshell is this:

We have two members of staff, MrsA ([email protected]) and MrsB
([email protected]). Some mail we get is shown (in the TO field in
the Inbox)
as going to MrsA but when you check the actual receiving email
address it is
(e-mail address removed). Of course, if we open an e-mail, right click the
to-field
and click on properties, Outlook gives us the recipient's email
address. Is
there any way to extract this information and display it in the
Outlook
Inbox? Can this be achieved by using VBasic? I have tried to create
a new
field using the [E-mail Account] field and the Iff command but have
been
unable to get it to work.

Many thanks in advance.




You could ask in a programming group.
--
Russ Valentine
[MVP-Outlook]
Thanks for all your help. If I open an e-mail, right click the
to-field
and
click on properties, Outlook gives me the recipient's email
address. Is
there
really no way to extract this information and display it in the
Outlook
Inbox? Can this be achieved by using VBasic?

:

That would be controlled by the sender, not the recipient.
--
Russ Valentine
[MVP-Outlook]
In the TO field in the Outlook Inbox. We have two members of
staff,
MrsA
([email protected])and MrsB ([email protected]). Some mail we get
is
shown
(in
the TO field in the Inbox) as going to MrsA but when you check
the
actual
receiving email address it is (e-mail address removed). We need to know
who
received
the email, i.e. the receiving email address. I have tried the
create a
field
using the [E-mail Account]field and the Iff command but have
been
unable
to
get it to work.

:

Display it where?
--
Russ Valentine
[MVP-Outlook]
I use Outlook2002 and Windows XP. How do I display
recepient's email
address,
instead of the name, in the TO field in Outlook? The problem
we have
it
that
we receive e-mails which say they are addressed to Test
Example (who
works
for us and whose e-mail address is
(e-mail address removed)). When
you
check
the recepient's e-mail address it is someone else in the
firm. I
have
tried
to create my own field and use the Iff function and the
[E-mailo
account]
field but cannot get it to work. Any ideas? Many thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top