Clear name cache with VBA

[Guest]

Is it possible to clear the name cache from the .pst using VBA?

 

[Ken Slovak - [MVP - Outlook]]

If you mean the "nickname" list it's stored in the file system as an .NK2
file. It's not in the mail store.

 

[Guest]

Thank you. Pardon my ignorance. I was referring to the name cache (as it is
referred to in various help files) that is used to Autocomplete email
addresses in the To: block of a new message. I found a reference on
Microsoft Top 10 Tips for Outlook to delete the .nk2 file to delete the
cache. This works, so that the list of emails does not appear when entering
a previously sent email address.

Actually, would you know how to ask the path to the .NK2 file from within a
VBA procedure? I am running a procedure from Access to modify Outlook data.

 

[Ken Slovak - [MVP - Outlook]]

The path is C:\Documents and Settings\<windows logon>\Application
Data\Microsoft\Outlook\<profile_name>.nk2.

You can query the Win32 API call SHGetFolderPath to get the path to
\Application Data. From there you can concatenate the rest of the name up to
the profile name. The usage for SHGetFolderPath is in the MSDN library.

The profile name is the hard part. You'd have to use Extended MAPI and
IOlkAccountManager using C++ or Delphi. For VBA/VB you would need to use the
Redemption.RDOSession.ProfileName property. Redemption is a 3rd party
library at www.dimastr.com/redemption