J
Jack@HPE
The below is a document that I received, which I greatly
appreciate, but it did helped to set up titles for columns.
Using Excell to import to and from to Outlook, I finally
got it to import a name record, but no address and they it
also created 32,624 more blank records. I am beginning to
come under the gun to get this address book from AOL to
Outlook.
The AOL address book was a pain. I had to print it to a
file and the take that file and clean out the aol label
that had no baring on any data, then because it did not
have the first character, I had to correct that and then
take the data and create a sting with name and e-mail
addresses, comma delimited because some of the names had 3
or more names in that filed.
When I tell it to import using excell, I am unable to see
all the data with I try to map where I need to data to go.
I have done this with text, and it all showed, but I could
not create a distribution line.
I would appreciate some help. Thanks.
Jack Privitt
HPE Computer Specialist
866-473-2667
501-812-9900
___________________________________
This is the kind of task I prefer using excel for.
Open a new excel worksheet.
File - Import your txt file with the AOL info.
Use Data - Text to Columns to run a wizard which will
allow you to separate the parts of your text file into
separate columns. Use the delimiter option. Select
spaces as the delimiter, ie, the character which tells the
wizard to break the line of text into columns. Allow it
to replace the data currently in the cells.
On the row above the data-now-in-columns, create labels
such as firstName, LastName, SMTPAddress. Use Edit-Insert
row if you need to. SMTPAddress should be the email
addresses.
To check if the converted text strings are ok, put your
cursor in the row with the lables, and go to Data-Filter-
Autofilter. Drop down list icons will appear in each of
the column label cells. Click the SMTPAddress drop down
list and scan the list which appears. You should be able
to immediately see any errors. Select the error in the
drop down box - excel will bring up the entire record for
editing.
Save the xls file.
Open Outlook, delete all your failed contact imports.
Then go to File - Import - Import from a different
program, and select Excel as the program type. Browse for
your .xls file. You will be prompted to confirm the
mapping of the fields, ie which columns from the excel
speadsheet should go into which fields in the Contact.
Use caution. You want to import the email address into the
email1 field. The first and last names should be mapped
to the corresponding Outlook fields, not the full name
field.
Best of luck!
appreciate, but it did helped to set up titles for columns.
Using Excell to import to and from to Outlook, I finally
got it to import a name record, but no address and they it
also created 32,624 more blank records. I am beginning to
come under the gun to get this address book from AOL to
Outlook.
The AOL address book was a pain. I had to print it to a
file and the take that file and clean out the aol label
that had no baring on any data, then because it did not
have the first character, I had to correct that and then
take the data and create a sting with name and e-mail
addresses, comma delimited because some of the names had 3
or more names in that filed.
When I tell it to import using excell, I am unable to see
all the data with I try to map where I need to data to go.
I have done this with text, and it all showed, but I could
not create a distribution line.
I would appreciate some help. Thanks.
Jack Privitt
HPE Computer Specialist
866-473-2667
501-812-9900
___________________________________
This is the kind of task I prefer using excel for.
Open a new excel worksheet.
File - Import your txt file with the AOL info.
Use Data - Text to Columns to run a wizard which will
allow you to separate the parts of your text file into
separate columns. Use the delimiter option. Select
spaces as the delimiter, ie, the character which tells the
wizard to break the line of text into columns. Allow it
to replace the data currently in the cells.
On the row above the data-now-in-columns, create labels
such as firstName, LastName, SMTPAddress. Use Edit-Insert
row if you need to. SMTPAddress should be the email
addresses.
To check if the converted text strings are ok, put your
cursor in the row with the lables, and go to Data-Filter-
Autofilter. Drop down list icons will appear in each of
the column label cells. Click the SMTPAddress drop down
list and scan the list which appears. You should be able
to immediately see any errors. Select the error in the
drop down box - excel will bring up the entire record for
editing.
Save the xls file.
Open Outlook, delete all your failed contact imports.
Then go to File - Import - Import from a different
program, and select Excel as the program type. Browse for
your .xls file. You will be prompted to confirm the
mapping of the fields, ie which columns from the excel
speadsheet should go into which fields in the Contact.
Use caution. You want to import the email address into the
email1 field. The first and last names should be mapped
to the corresponding Outlook fields, not the full name
field.
Best of luck!