how to print address labels from excel 2010

In Word 2003, leave All selected and choose Print. If you're happy with the look of your labels, click 'Next: Complete the merge' in Word 2003 or Finish & Merge in Word 2007. In Word 2003, click 'Next: Preview your labels,' and in Word 2007 click Preview Results. The address block will appear in each label following 'Next Record.'

Now choose 'Update all labels' in Word 2003 or Update Labels in Word 2007. In both versions, make any necessary changes to the address layout and click OK. In Word 2007, place the cursor in the first label and click Address Block. In Word 2003, click 'Next: Arrange your labels' and choose Address Block. Modify, sort, and filter your list of Outlook contacts before you create your mailing labels. When the list looks the way you want it, click OK. In the Mail Merge Recipients dialog box, you can uncheck any names you want to remove from the list, sort the list by any category, or filter it. In both versions, choose 'Select from Outlook contacts,' click Choose Contacts Folder, and select the Outlook contact folder you just created. In Word 2007, click Start Merge > Labels, select your label layout, click OK, and choose Select Recipients. Choose 'Next: Select recipients' at the bottom of the task pane. Now choose 'Change document layout,' click Label Options, select the layout you prefer, and click OK. In Word 2003, click the Labels button in the Mail Merge task pane and click Next.

With your new contact folder in place, click Tools > Letters and Mailings > Mail Merge in Word 2003 or the Mail Merge tab on Word 2007's ribbon. Instead, move the contacts whose addresses you want to print into a new folder in Outlook's contact list. And every time I tried to run the resulting wizard, Word stalled in mid-process. If you use Outlook's own mail-merge function by clicking Tools > Mail Merge, you get kicked into Word anyway. The first bit of counter-intuitivity is that you use Microsoft Word, not Outlook. You would think that such a basic operation would be a breeze for an industrial-strength personal-information manager like Outlook. A friend asked if it's possible to print a subset of the addresses in her Microsoft Outlook contacts as mailing labels.

How to print address labels from excel 2010