Exporting contacts to another user on the same computer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruiser - 03 Feb 2004 02:54 GMT

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

Reply to this Message

Russ Valentine [MVP-Outlook] - 03 Feb 2004 10:19 GMT

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

Signature

Russ Valentine
[MVP-Outlook]

> WinXP Home, Outlook 2003
>
[quoted text clipped - 8 lines]
> Thanks
> Bruce

Reply to this Message

Bruiser - 04 Feb 2004 01:19 GMT

>> 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

Reply to this Message

Russ Valentine [MVP-Outlook] - 04 Feb 2004 02:57 GMT

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?

Signature

Russ Valentine
[MVP-Outlook]

> >> Why export? Why change file format? Just copy the Contacts into a
> >> new PST file.
[quoted text clipped - 9 lines]
> Thanks,
> Bruce

Reply to this Message

Bruiser - 04 Feb 2004 23:46 GMT

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
[quoted text clipped - 14 lines]
> > Thanks,
> > Bruce

Reply to this Message

Russ Valentine [MVP-Outlook] - 05 Feb 2004 00:22 GMT

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.

Signature

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.
[quoted text clipped - 26 lines]
> > > Thanks,
> > > Bruce

Reply to this Message

Bruiser - 05 Feb 2004 01:07 GMT

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
[quoted text clipped - 37 lines]
>>>>> Thanks,
>>>>> Bruce

Reply to this Message

Bruiser - 06 Feb 2004 02:24 GMT

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

<SNIP>

>> Russ Valentine [MVP-Outlook] wrote:
>>>> Ick.
[quoted text clipped - 20 lines]
>>>>> Thanks,
>>>>> Bruce

<SNIP

Reply to this Message

Russ Valentine [MVP-Outlook] - 06 Feb 2004 10:14 GMT

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

Signature

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
[quoted text clipped - 43 lines]
> >>>>>
> <SNIP

Reply to this Message

Bruiser - 07 Feb 2004 01:53 GMT

>> 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

<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.

Reply to this Message