Convert Word Document to vCard

[dw...@historyassociates.com]

One of our users gave me a lengthy address list in Word (as a straight
list, not as a table). It includes home addresses, work addresses,
phone numbers, e-mail addresses, etc. He wants me to convert it to
vCard. The only instructions I found online are for converting
Outlook contacts to vCard. Is there any way to convert this Word doc
to vCard, even if I have to convert it to Excel first?

[Unknown]

You might try to Search for Microsoft help here... if there is
an article describing a method, it will be found starting here

http://search.microsoft.com/search.aspx?mkt=en-US&setlang=en-US

[Diane Poremsky [MVP]]

Are the records in a table? If so, you can import it. If not, copy and paste
to Excel and put one record per row.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-sub...@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-S...@PEACH.EASE.LSOFT.COM

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

<dw...@historyassociates.com> wrote in message
news:9b88a9e9-94e8-4d42...@m32g2000hsf.googlegroups.com...

[dw...@historyassociates.com]

On Oct 29, 10:31 pm, "Diane Poremsky [MVP]" <outlook...@msn.com>
wrote:

> Are the records in a table? If so, you can import it. If not, copy and paste
> to Excel and put one record per row.
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips:http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center:http://www.slipstick.com
>
> Outlook Tips by email:

> dailytips-subscribe-requ...@lists.outlooktips.net

>
> EMO - a weekly newsletter about Outlook and Exchange:

> EMO-NEWSLETTER-SUBSCRIBE-REQU...@PEACH.EASE.LSOFT.COM
>
> You can access this newsgroup by visitinghttp://www.microsoft.com/office/community/en-us/default.mspxor point your

> newsreader to msnews.microsoft.com.
>
> <dw...@historyassociates.com> wrote in message
>
> news:9b88a9e9-94e8-4d42...@m32g2000hsf.googlegroups.com...
>
>
>
> > One of our users gave me a lengthy address list in Word (as a straight
> > list, not as a table).  It includes home addresses, work addresses,
> > phone numbers, e-mail addresses, etc.  He wants me to convert it to
> > vCard.  The only instructions I found online are for converting
> > Outlook contacts to vCard.  Is there any way to convert this Word doc

> > to vCard, even if I have to convert it to Excel first?- Hide quoted text -
>
> - Show quoted text -

It's not in a table, so I will copy and paste to Excel and put one
record per row. After I do that, in what format should I save the
Excel document? Then how do I go about converting the Excel document
into vCard format?

[Diane Poremsky [MVP]]

Save it as either excel or CSV format. If you do it in Excel format
(97-2003, not 2007 format) - you'll need to name the range.

Also - in case you aren't familiar with Excel's paste special, transpose -
if the word file is in the form of
name
address
city

You can copy and use paste special, transpose to get it into Excel in one
step. When I needed to do it, I copied by pages (using paste special) and
then drag and dropped the records to the rows. If the city, state and zip
need split into cells its fairly easy with formulas (then copy and paste
special, values to replace the formulas with hard values).

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-sub...@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:

EMO-NEWSLETTER-S...@PEACH.EASE.LSOFT.COM

You can access this newsgroup by visiting

http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

<dw...@historyassociates.com> wrote in message
news:54be06f0-9331-473d...@y71g2000hsa.googlegroups.com...

[dw...@historyassociates.com]

On Oct 30, 5:04 pm, "Diane Poremsky [MVP]" <outlook...@msn.com> wrote:
> Save it as either excel or CSV format. If you do it in Excel format
> (97-2003, not 2007 format) - you'll need to name the range.
>
> Also - in case you aren't familiar with Excel's paste special, transpose -
> if the word file is in the form of
> name
> address
> city
>
> You can copy and use paste special, transpose to get it into Excel in one
> step.  When I needed to do it, I copied by pages (using paste special) and
> then drag and dropped the records to the rows. If the city, state and zip
> need split into cells its fairly easy with formulas (then copy and paste
> special, values to replace the formulas with hard values).
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips:http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center:http://www.slipstick.com
>
> Outlook Tips by email:

> > into vCard format?- Hide quoted text -

>
> - Show quoted text -

OK. So after I do that, how do I convert it to a vcf file?

[Diane Poremsky [MVP]]

You need to import it into Contacts using file import.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-sub...@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:

EMO-NEWSLETTER-S...@PEACH.EASE.LSOFT.COM

You can access this newsgroup by visiting

http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

<dw...@historyassociates.com> wrote in message
news:a5ec4caa-b7ac-4bab...@f37g2000pri.googlegroups.com...

[dw...@historyassociates.com]

On Oct 31, 11:36 am, "Diane Poremsky [MVP]" <outlook...@msn.com>
wrote:

> You need to import it into Contacts using file import.
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips:http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center:http://www.slipstick.com
>
> Outlook Tips by email:

> > OK.  So after I do that, how do I convert it to a vcf file?- Hide quoted text -

>
> - Show quoted text -

When I import it into Contacts, doesn't it just make it part of the
pst file? Or is there an option to save it as a vcf file?

[Diane Poremsky [MVP]]

> When I import it into Contacts, doesn't it just make it part of the
> pst file? Or is there an option to save it as a vcf file?

Once its imported you can save the contacts as vcf files outside of outlook.
Or you can learn to write your own vcf's using notepad. The basic layout is
here: http://www.w3.org/2002/12/cal/vcard-notes.html

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-sub...@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:

EMO-NEWSLETTER-S...@PEACH.EASE.LSOFT.COM

You can access this newsgroup by visiting

http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

<dw...@historyassociates.com> wrote in message
news:9806457f-da4e-4eee...@b2g2000prf.googlegroups.com...