Import and export

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 07 Jan 2004 12:37 GMT

Hello Friends,
As per this link
http://www.1800partyshop.com/pdfs/newpdfs/outlookinfo.pdf

I am trying to import an .xls file into outlook XP
contacts. All it's doing well but at the end I can see only
blank lines (no contacts are imported)

OS= w2k with sp4
Outlook xp with sp2

Reply to this Message

Rifleman - 07 Jan 2004 13:08 GMT

> Hello Friends,
> As per this link
[quoted text clipped - 6 lines]
> OS= w2k with sp4
> Outlook xp with sp2

You might be better off saving as a csv file and trying that.

Reply to this Message

Karl Timmermans - 07 Jan 2004 21:22 GMT

Sounds like it's a simple issue of the "named range" not being correctly set
up in Excel - that would be the first thing to check and ensure it
encompasses the data you want to import (or as someone else suggested -
simply export the info as a csv file and import that).

Karl

Signature

___________________________________
Karl Timmermans - The Claxton Group

ContactGenie - "automated contact importer for MS Outlook '2000/2002

http://contactgenie.claxton.com

> Hello Friends,
> As per this link
[quoted text clipped - 6 lines]
> OS= w2k with sp4
> Outlook xp with sp2

Reply to this Message

K Kellie - 08 Jan 2004 17:27 GMT

I have successfully imported contacts into Outlook. Just
make sure the excel file is saved as a CSV file.
In Outlook you import the file (File, Import and
Export....From another program or file)
Then you will have to match up the fields from the CSV
file to the fields in the Contact form. But it's all
visual drag and drop stuff, so you shouldn't have any
trouble.
K

>-----Original Message-----
>Sounds like it's a simple issue of the "named range" not being correctly set
[quoted text clipped - 6 lines]
>> Hello Friends,
>> As per this link

http://www.1800partyshop.com/pdfs/newpdfs/outlookinfo.pdf

>> I am trying to import an .xls file into outlook XP
>> contacts. All it's doing well but at the end I can see only
[quoted text clipped - 4 lines]
>
>.

Reply to this Message

Artmacom - 09 Jan 2004 06:25 GMT

But, check this one out!

I exported my Contacts from an Outlook program on my
notebook into a .csv file. When I try to import my .csv
file of Contacts into the Outlook program on my desktop,
Outlook gives me a Dr. Watson and closes as soon as I
click on "Next" after clicking on the "Import from
another program or file" line in the Import and Export
Wizard. I am using MS Outlook 2002 (10.4712.4219) SP-2
on XP.

Interestingly, if I choose another type of file from the
window in the Import and Export Wizard, such as "Import a
VCard (.vcf) file," the application does not crash.
However, I do not have my contacts in that file type.
file type

Do you have any idea what might be the problem?

Thanks,
Art Macomber

>-----Original Message-----
>I have successfully imported contacts into Outlook. Just
[quoted text clipped - 39 lines]
>>
>.

Reply to this Message