How do I convert an Excel data list into mailing labels?

Answer 1

Hi,

Assuming you have valid data in the Excel and MS Word, take the following steps

1. Open MS Word
2. Tool
3. Letters and Mail
4. Mail Merge
5. Select Label
6. You will have to provide the number of paper (you can find it on the label paper you have)

These steps are for Word 2003. Menu options may be different for other version of Word

Answer 2

I just figured this one out myself.

1. Open Word

2. In word go to Tools - Letters and Mailings - Mail merge wizard

3. Select labels Click Next at bottom

4. Start from existing file - search for the file you want and choose it.

It is really just following the steps from there.

Answer 3

in case you advise mailing labels then you truly can try this with the "envelopes and labels" function from interior Microsoft word. Excel does not do mailing labels besides the shown fact that it relatively is somewhat happy to proportion a expertise source with word for this activity. The proper term interior the labels (or mail merge) technique in word is "information source". that's going to ask you in case you opt for to opt for a expertise source and you compromise and bypass browse for the excel document.

Answer 4

type in every column the name, address
then link to MS word by using the mail merge

Answer 5

I suppose you could just do a simple paste special in Word, and prin from there