Accessing email addresses in VBA

[MWE]

I am running Outlook2000 and WinXP (SP1). I have a VBA routine in Outlook
that sequences through mailitems in a folder. If I fetch an email address,
e.g., SenderName, FromAddress or ReplyToAddress, a security window pops up
indicating that the "Project is trying to access email address stored in
Outlook" and aksing if this is OK. Selecting the YES box allows access one
time. Checking the "Allow access for XX minutes" box is supposed to allow
access for XX minutes. Prior to updating WinXP two weeks ago (with all
"critical updates" for SP1), the address access process worked as it should.
Now I can access only a single mailitem before the security window reappears.

Any ideas what might be happening here?

I noticed some changes in MSOffice after the o/s update. For example:
o ... several settings in Word have gone back to "default", e.g., default
file locations
o ... word VBA code is intact, personal menus are intact but the linkage
from menu picks to the macros is gone
o ... I use Word as my editor in Outlook so when I compose a message, my the
Word menubar is displayed including my personal menus. You guessed it, the
menu pick linkages work when running "inside" Outlook but not when Word is
running standalone.
o ... macro security was reset to "high" for Word macros (but not for excel,
access, powerpoint, or outlook).

 

[Michael Bauer]

please take a look at Sue´s site:

Microsoft Outlook "Object Model Guard" Security Issues for Developers:
http://www.outlookcode.com/d/sec.htm


--
Viele Grüße
Michael Bauer

I am running Outlook2000 and WinXP (SP1). I have a VBA routine in Outlook
that sequences through mailitems in a folder. If I fetch an email address,
e.g., SenderName, FromAddress or ReplyToAddress, a security window pops up
indicating that the "Project is trying to access email address stored in
Outlook" and aksing if this is OK. Selecting the YES box allows access one
time. Checking the "Allow access for XX minutes" box is supposed to allow
access for XX minutes. Prior to updating WinXP two weeks ago (with all
"critical updates" for SP1), the address access process worked as it should.
Now I can access only a single mailitem before the security window

reappears.

 

[Jim Vierra]

I recommend using the following add-in to circumvent the security issue. I
will do most of what you need I believe and it is free.

http://www.mapilab.com/download/

It's at the bottom of the page "MAPIProp" under "For Developers"

 

[Michael Bauer]

I

will do most of what you need I believe and it is free.

*What* do you want to do? I hope it is OL related

 

[TJG]

Hi MWE!

You don't happen to have a VBA routine to extract the receipient's email
address (not the to-field as that sometimes displays the receipient's name
and not his email address)? We use Outlook 2002 and Windows/Office XP.

My email is: (e-mail address removed)

 

[Sue Mosher [MVP-Outlook]]

To get the SMTP address from an Exchange sender or recipient, use CDO or
Redemption and the PR_EMAIL (&H39FE001E) MAPI property to obtain the SMTP
address from the AddressEntry object. See
http://www.outlookcode.com/d/code/getsenderaddy.htm#redemption and
http://www.cdolive.com/cdo5.htm#EMailAddressOfSender for examples.


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers