Wie heißen die Outlook Kontakte Spaltennamen auf englisch?
Problem:
In manchen Fällen möchte man per VBA auf die Outlook Kontakte zugreifen. In diesem Fall benötigt man jedoch die englischen Spaltennamen.
Auch wenn man per Access eine Verknüpfung zur Tabelle erstellt, erhält man nur die deutschen Spaltennamen. Diese können aber in VBA nicht verwendet werden.
Lösung:
Eine gute Anleitung dazu finden Sie hier:
http://www.msxfaq.de/code/kontaktfelder.htm
Auch dieser Link ist einen Blick wert:
http://msdn.microsoft.com/en-us/library/cc513843.aspx
Account | |
Anniversary | |
AssistantName | |
AssistantTelephoneNumber | |
AutoResolvedWinner | |
BillingInformation | |
Birthday | |
Body | (Notizen) |
Business2TelephoneNumber | |
BusinessAddress | |
BusinessAddressCity | (Geschäftlich Ort) |
BusinessAddressCountry | (Geschäftlich Land) |
BusinessAddressPostalCode | (Geschäftlich PLZ) |
BusinessAddressPostOfficeBox | |
BusinessAddressState | (Geschäftlich Bundesland) |
BusinessAddressStreet | (Geschäftlich Strasse) |
BusinessCardLayoutXml | |
BusinessFaxNumber | |
BusinessHomePage | |
BusinessTelephoneNumber | |
CallbackTelephoneNumber | |
CarTelephoneNumber | |
Categories | |
Companies | |
CompanyAndFullName | |
CompanyLastFirstNoSpace | |
CompanyLastFirstSpaceOnly | |
CompanyMainTelephoneNumber | |
CompanyName | (Firma) |
ComputerNetworkName | |
Conflicts | |
ConversationIndex | |
ConversationTopic | |
CreationTime | |
CustomerID | |
Department | |
DownloadState | |
Email1Address | |
Email1AddressType | |
Email1DisplayName | |
Email1EntryID | |
Email2Address | |
Email2AddressType | |
Email2DisplayName | |
Email2EntryID | |
Email3Address | |
Email3AddressType | |
Email3DisplayName | |
Email3EntryID | |
EntryID | |
FileAs | |
Firma | |
FirstName | (Vorname) |
FullName | |
FullNameAndCompany | |
Gender | |
GovernmentIDNumber | |
HasPicture | |
Hobby | |
Home2TelephoneNumber | |
HomeAddress | |
HomeAddressCity | |
HomeAddressCountry | |
HomeAddressPostalCode | |
HomeAddressPostOfficeBox | |
HomeAddressState | |
HomeAddressStreet | |
HomeFaxNumber | |
HomeTelephoneNumber | |
IMAddress | |
Importance | |
Initials | |
InternetFreeBusyAddress | |
IsConflict | |
ISDNNumber | |
IsMarkedAsTask | |
JobTitle | |
Journal | |
Language | |
LastFirstAndSuffix | |
LastFirstNoSpace | |
LastFirstNoSpaceAndSuffix | |
LastFirstNoSpaceCompany | |
LastFirstSpaceOnly | |
LastFirstSpaceOnlyCompany | |
LastModificationTime | |
LastName | (Nachname) |
LastNameAndFirstName | |
Links | |
MailingAddress | |
MailingAddressCity | |
MailingAddressCountry | |
MailingAddressPostalCode | |
MailingAddressPostOfficeBox | |
MailingAddressState | |
MailingAddressStreet | |
ManagerName | |
MarkForDownload | |
MessageClass | |
MiddleName | |
Mileage | |
MobileTelephoneNumber | |
NetMeetingAlias | |
NetMeetingServer | |
NickName | |
NoAging | |
OfficeLocation | |
OrganizationalIDNumber | |
OtherAddress | |
OtherAddressCity | |
OtherAddressCountry | |
OtherAddressPostalCode | |
OtherAddressPostOfficeBox | |
OtherAddressState | |
OtherAddressStreet | |
OtherFaxNumber | |
OtherTelephoneNumber | |
OutlookInternalVersion | |
OutlookVersion | |
PagerNumber | |
PersonalHomePage | |
PrimaryTelephoneNumber | |
PrivatStrasseLine2 | |
Profession | |
PropertyAccessor | |
RadioTelephoneNumber | |
ReminderOverrideDefault | |
ReminderPlaySound | |
ReminderSet | |
ReminderSoundFile | |
ReminderTime | |
SelectedMailingAddress | |
Sensitivity | |
Size | |
Spouse | |
Subject | |
Suffix | |
TaskCompletedDate | |
TaskDueDate | |
TaskStartDate | |
TaskSubject | |
TelexNumber | |
Title | |
ToDoTaskOrdinal | |
TTYTDDTelephoneNumber | |
User1 | |
User2 | |
User3 | |
User4 | |
UserProperties | |
WebPage | |
WeitereLand | |
YomiCompanyName | |
YomiFirstName | |
YomiLastName |