Beyond the Help files . . .

 

 

Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows  ¨  Free Downloads


 


 

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.

 

Back to top...

 

 

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved