printing labels in mailmerge wizard from excel doc.

[blue heron]

Sorry. I was vague in my last e-mail. These are the steps
I followed and where I go wrong: 1) open Word. 2)
tools>Letters and mailings>mail merge wizard. 3)'Labels'
radio button; scroll down to the bottom and click 'next:
starting document'. 4)'Start from existing document'
radio button, then I open the excel file I need. 5)It
asks 'Entire workbook' so I scroll to the other option,
which is my particular "Worksheet" then I open it.
When it opens it's not in label format but I have faith
and follow the steps anyway.6) I click 'next: Select
recipients'. Here's where I get confused. A) I'm not
writing a letter to go with the labels, and, B) it seems
I have to brouse thru the same thing and open the exact
same file all over again. Thanks in advance...

 

[Debra Dalgleish]

For 'Select starting document', leave the option set as 'Change document
layout', and click on 'Label options'.

Select a label, e.g. Avery 5160-Address, click OK
Click Next: Select recipients
Under 'Use an existing list', click Browse
Select your Excel file, click Open
Select 'Microsoft Excel Worksheets via Converter', click OK
Select the sheet that contains your mailing list, click OK
The list of recipients should appear, click OK
Click Next:Arrange your labels
Click 'More items...'
Select a field, and click Insert.
Add punctuation, and line breaks if required
Add more items to complete the label
Go to Steps 5 and 6 to preview and print the labels.