Exporting contacts to another user on the same computer

[Bruiser]

WinXP Home, Outlook 2003

I'm trying to export the contacts from one user to another on an XP Home
system. When I choose to export to an Excel file and then import that file
in the other user's Outlook, the e-mail addresses get dropped. On a side
note, the e-mail addresses in the first user's Outlook are not hyperlinked
as the web page field is. Shouldn't it be?

Is there a better way to do this in order to keep the e-mail addresses?

Thanks
Bruce

 

[Russ Valentine [MVP-Outlook]]

Why export? Why change file format? Just copy the Contacts into a new PST
file.

 

[Bruiser]

Because I'm brand new to Outlook and this seemed the intuitive thing to do.
As it turns out, I did do an export/import, but did it to a .cvs file format
and I was able to keep the e-mail addresses that way.

On a related note, is there a way to import a list of addresses that were
created in Word as part of a mail merge to create labels? The data source
file is a .doc.

Thanks,
Bruce

 

[Russ Valentine [MVP-Outlook]]

Ordinarily, mail merges export data to temporary files which cannot be
accessed by the Import Wizard. Do you know how these .doc files were
created?

 

[Bruiser]

It was done in Word 97, by using the label wizard to create a data source
file (.doc) which mail merge used to create mailing labels.

What I have saved is the source file which, when opened in Word, is a
document table with nine fields. What I'm hoping is that there is some way
to import this information into Contacts.

Thanks,
Bruce

Ordinarily, mail merges export data to temporary files which cannot be
accessed by the Import Wizard. Do you know how these .doc files were
created?
--
Russ Valentine
[MVP-Outlook]

Because I'm brand new to Outlook and this seemed the intuitive thing to do.
As it turns out, I did do an export/import, but did it to a .cvs file format
and I was able to keep the e-mail addresses that way.

On a related note, is there a way to import a list of addresses that were
created in Word as part of a mail merge to create labels? The data source
file is a .doc.

Thanks,
Bruce

 

[Russ Valentine [MVP-Outlook]]

Ick.
So you created a new data source as a Word Table instead of using an
existing Outlook data source. And in a version of Word so ancient it is no
longer even supported.
I haven't seen Word 97 for years. I would see if you can save that table in
a format that Outlook can import, like CSV, for instance. Beyond that, I
would have no clue. You are operating in a different century.
--
Russ Valentine
[MVP-Outlook]

It was done in Word 97, by using the label wizard to create a data source
file (.doc) which mail merge used to create mailing labels.

What I have saved is the source file which, when opened in Word, is a
document table with nine fields. What I'm hoping is that there is some way
to import this information into Contacts.

Thanks,
Bruce

Ordinarily, mail merges export data to temporary files which cannot be
accessed by the Import Wizard. Do you know how these .doc files were
created?
--
Russ Valentine
[MVP-Outlook]

Russ Valentine [MVP-Outlook] wrote:
Why export? Why change file format? Just copy the Contacts into a
new PST file.

Because I'm brand new to Outlook and this seemed the intuitive thing

to
do.

As it turns out, I did do an export/import, but did it to a .cvs file format
and I was able to keep the e-mail addresses that way.

On a related note, is there a way to import a list of addresses that were
created in Word as part of a mail merge to create labels? The data source
file is a .doc.

Thanks,
Bruce

 

[Bruiser]

LOL, "Ick" is right.

Yes, it was done last year on this ancient HP computer at work (we've since
gotten a brand new one with XP, Office 2003 and everything, hot damn!!); at
that time, we needed 200 labels fast and it did it for us.

The source .doc looks as if it will save to Excel (no mention of .csv), so
that might at least save the info, we'll see. On the plus side, my boss is
seeing clearly that the $$ spent on the new computer was well spent!

Thanks,
Bruce

Ick.
So you created a new data source as a Word Table instead of using an
existing Outlook data source. And in a version of Word so ancient it
is no longer even supported.
I haven't seen Word 97 for years. I would see if you can save that
table in a format that Outlook can import, like CSV, for instance.
Beyond that, I would have no clue. You are operating in a different
century. --
Russ Valentine
[MVP-Outlook]

It was done in Word 97, by using the label wizard to create a data
source file (.doc) which mail merge used to create mailing labels.

What I have saved is the source file which, when opened in Word, is
a document table with nine fields. What I'm hoping is that there is
some way to import this information into Contacts.

Thanks,
Bruce

Ordinarily, mail merges export data to temporary files which
cannot be accessed by the Import Wizard. Do you know how these
.doc files were created?
--
Russ Valentine
[MVP-Outlook]
Russ Valentine [MVP-Outlook] wrote:
Why export? Why change file format? Just copy the Contacts into
a new PST file.

Because I'm brand new to Outlook and this seemed the intuitive
thing to do. As it turns out, I did do an export/import, but did
it to a .cvs file format and I was able to keep the e-mail
addresses that way.

On a related note, is there a way to import a list of addresses
that were created in Word as part of a mail merge to create
labels? The data source file is a .doc.

Thanks,
Bruce

 

[Bruiser]

Russ, I was able to copy/paste the info from the original .doc source file
into Excel. But I'm having trouble importing that into Outlook using the
Import/Export wizard, though. Here's what I'm doing:

1) I've named all of the ranges in the Excel spreadsheet (Title, FirstName,
LastName, etc.) so that Outlook won't complain when doing the import;

2) In the Outlook wizard, I select each field and custom map the named
ranges, but when it imports it the process seemingly hangs (there are 280+
entries). If I do just a sample of 3-4 entries, the import completes, but
every element is listed separately.

Clearly I'm doing something wrong, probably in the way I'm mapping, I don't
know. I keep looking in the Help for instructions (which I think I'm
following correctly), but am getting very frustrated. I feel I'm closing in,
though...

Bruce

Ick.
So you created a new data source as a Word Table instead of using
an existing Outlook data source. And in a version of Word so
ancient it
is no longer even supported.
I haven't seen Word 97 for years. I would see if you can save that
table in a format that Outlook can import, like CSV, for instance.
Beyond that, I would have no clue. You are operating in a different
century. --
Russ Valentine
[MVP-Outlook]
It was done in Word 97, by using the label wizard to create a data
source file (.doc) which mail merge used to create mailing labels.

What I have saved is the source file which, when opened in Word,
is
a document table with nine fields. What I'm hoping is that there
is some way to import this information into Contacts.

Thanks,
Bruce

<SNIP>

 

[Russ Valentine [MVP-Outlook]]

When you say you "named all the ranges" it doesn't sound like you did. What
you describe is simply labeling the fields, not naming a range.
Are you following the directions here?
http://support.microsoft.com/support/kb/articles/q196/7/43.asp


--
Russ Valentine
[MVP-Outlook]

Russ, I was able to copy/paste the info from the original .doc source file
into Excel. But I'm having trouble importing that into Outlook using the
Import/Export wizard, though. Here's what I'm doing:

1) I've named all of the ranges in the Excel spreadsheet (Title, FirstName,
LastName, etc.) so that Outlook won't complain when doing the import;

2) In the Outlook wizard, I select each field and custom map the named
ranges, but when it imports it the process seemingly hangs (there are 280+
entries). If I do just a sample of 3-4 entries, the import completes, but
every element is listed separately.

Clearly I'm doing something wrong, probably in the way I'm mapping, I don't
know. I keep looking in the Help for instructions (which I think I'm
following correctly), but am getting very frustrated. I feel I'm closing in,

though...

Bruce

Russ Valentine [MVP-Outlook] wrote:
Ick.
So you created a new data source as a Word Table instead of using
an existing Outlook data source. And in a version of Word so
ancient it
is no longer even supported.
I haven't seen Word 97 for years. I would see if you can save that
table in a format that Outlook can import, like CSV, for instance.
Beyond that, I would have no clue. You are operating in a different
century. --
Russ Valentine
[MVP-Outlook]
It was done in Word 97, by using the label wizard to create a data
source file (.doc) which mail merge used to create mailing labels.

What I have saved is the source file which, when opened in Word,
is
a document table with nine fields. What I'm hoping is that there
is some way to import this information into Contacts.

Thanks,
Bruce

<SNIP>

 

[Bruiser]

<SNIP>

I *finally* got it work, Russ. I was naming the fields separately rather
than selecting the entire range of cells to name as one thing. Once I got
that sorted out correctly, it imported perfectly.

Thanks for the link.

B.