print labels from excel worksheet

M

Marybeth

I have Microsoft Office 2007 - how do I convert an Excel spreadsheet into
Word to print labels?
 
D

Doug Robbins - Word MVP

In Word, from the Mailings tab of the Ribbon, click on the Start Mail Merge
item and then select Labels and then choose the type of label that you want
to use. Then click on the Select Recipients item in the Mail Merge section
of the ribbon and navigate to and select your spreadsheet. Then use the
Insert Merge Field item in the Write & Insert Fields section of the ribbon
to insert the mergefields that you want in the configuration that you want
them
into the first label on the sheet . Then click on the Update Labels button
in that section of the ribbon to replicate the set up to the other labels on
the sheet. Then click on the Finish and Merge button at the right hand end
of the ribbon.
--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top