• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Outlook Field(s) Question

I am writing a VBA program to map a Contacts File in Outlook to a Table in Access. Hasn't been easy but I'm pretty darn close. My question concerns mapping: what is the correct way to refere to a complete business address: Example

XYZ Company
123 Mockingbird Lane
4th Floor
Chicago
Illinois
60629

In Access this maps to the fields I created: Company, Address1,Address2, City, State, ZipCode;
In Outlook, using the default fields it's obvious that Company maps the same, as does City and State. ZipCode, Address1 and Address2, however, are confusing me a bit. Should Address1 be mapped to Business Address Street1 or BusinessAddressStreet1 or BusinessStreet1 or Business Street 1 0r ???...If I can figure out this example the rest should follow, right? How can I find out the Field names in Outlook for programming purposes? That would obviously solve my problem (well...at least this one!).Thanks.
0
rjusa
Asked:
rjusa
1 Solution
 
meschCommented:
You can find out the field names by using the object browser in Outlook. Open the VBE with ALT+F11. Press F2. Select Outlook in the ComboBox at the top. Select in the Contactitem object in the Class list on the left. On the right you will see all the properties and methods of an Outlook ContactItem.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now