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

[Sherry Lee]

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?

 

[Doug Robbins]

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

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

 

[Sherry Lee]

Thanks very much Doug. I will try that.

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

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

 

[Sherry Lee]

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