[Marybeth]

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

[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

"Marybeth" wrote in message
...
I have Microsoft Office 2007 - how do I convert an Excel spreadsheet into
Word to print labels?

[Graham Mayor]

http://www.gmayor.com/merge_labels_with_word_2007.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



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