Print Address Labels From Microsoft Excel


I've seen this asked a bunch of times. It seems so simple to me, but I'm sure there was a time when it was not; I just can't remember it.

Suppose you have a list of addresses, with columns such as Name, Address, City, State, and Zip, and you want to create labels or you want to send a letter to all of the people on the list.

Use Word's mail merge feature. Click here to find out how to create labels. Click here to find out how to create letters. If you have difficulty with your zip codes or other numbers not coming through properly, click here to learn how to fix it.

Note: To actually print address labels from Excel without using Word requires a macro.