 |
|
| Domino Tips: |
|
|
|
ADDRESS BOOK
Manually Import Outlook Contacts Into Notes
Jessica Spinosa
08.10.2000
Rating: -4.33- (out of 5)
This also works well in R5 with one small bug if the user has birthdays in
Outlook.
While this is a manual and requires some extra work, it is a viable alternative
if you are having trouble with any other migration tool.
You will need to correctly map the fields from Notes to your Excel sheet. The
fields are at the end of this document. There are extra fields... these are
fields that Notes does not use, but Outlook will export anyway.
I have listed them vertically. However, they are in the correct order to be
placed horizontally in each Excel column.
Code
1. Export your contacts into an Excel file.
1a. Be sure to go into "Map Custom Fields" and click on map default.
2. Go into the Excel file, and change headings to match those that I have made
(cut and paste).
3. Save it as a .WK4 file. (click yes when you get the warning that it is not
compatible)
4. Go into Notes, and your Personal Address Book.
5. Click 'File -> Import'
6. Select your .WK4 file, and select the following:
6a.
- Use "Form Business Card" (or "Contact" if using R5)
- WKS Title Defined
- Calculate fields on form during import
7. Click OK, and watch what happens.
EXCEL FIELDS
Title
FirstName
MiddleInitial
LastName
Suffix
CompanyName
Department
JobTitle
OfficeStreetAddress
BusinessStreet2
BusinessStreet3
OfficeCity
OfficeState
OfficeZip
OfficeCountry
StreetAddress
HomeStreet2
HomeStreet3
City
State
Zip
Country
OtherStreet
OtherStreet2
OtherStreet3
OtherCity
OtherState
OtherPostalCode
OtherCountry
AssistantsPhone
OfficeFaxPhoneNumber
OfficePhoneNumber
BusinessPhone2
Callback
CellPhoneNumber
OfficePhoneNumber
HomeFaxPhoneNumber
PhoneNumber
HomePhone2
ISDN
MobilePhone
OtherFax
OtherPhone
Pager
PrimaryPhone
RadioPhone
TTYTDDPhone
Telex
Account
Anniversary
Assistant
BillingInformation
Birthday
Categories
Children
DirectoryServer
MailAddress
MailAddress
Email2Address
Email2DisplayName
Email3Address
Email3DisplayName
Gender
GovernmentIDNumber
Hobby
Initials
InternetFreeBusy
Keywords
Language1
Location
ManagersName
Mileage
Comment
OfficeLocation
OrganizationalIDNumber
POBox
Priority
Private Profession
ReferredBy
Sensitivity
Spouse
User1
User2
User3
User4
WebSite
|
|
Rate this Tip
|
To rate tips, you must be a member of SearchDomino.com.
Register now
to start rating these tips. Log in if you are already a member.
|
DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.
|
|
|
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
