Importing an excel document (address list) to a Word address book

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sherry Lee - 17 Aug 2005 20:27 GMT

I am trying to import an address list from excel to an address lbook in Word
so I can print labels for the names in the address list. Any suggestions?

Reply to this Message

Doug Robbins - 18 Aug 2005 04:53 GMT

Use the Excel file as the data source for a label type mailmerge in Word.

If you are using XP of 2003,

See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to import an address list from excel to an address lbook in
>Word
> so I can print labels for the names in the address list. Any suggestions?

Reply to this Message

Sherry Lee - 18 Aug 2005 05:14 GMT

Thanks very much Doug. I will try that.

> Use the Excel file as the data source for a label type mailmerge in Word.
>
[quoted text clipped - 8 lines]
> >Word
> > so I can print labels for the names in the address list. Any suggestions?

Reply to this Message

Sherry Lee - 19 Aug 2005 01:17 GMT

Thanks again. I almost got it right - have to make a few modifications to
the excel spreadsheet but then I can finally print labels.

> Use the Excel file as the data source for a label type mailmerge in Word.
>
[quoted text clipped - 8 lines]
> >Word
> > so I can print labels for the names in the address list. Any suggestions?

Reply to this Message