How do you print mailing labels???

[buster2cajun]

HELP! I work on a Mac iBook, OS 9.2 & use MS Word 98 & MS Excel 98. I
have a list of friends mailing addresses saved in an Excel Worksheet.
I bought sheets of Avery Labels that are the 8660 format (1 sheet has
30 labels, 3 columns & 10 rows), to insert into my HP Inkjet printer.
I don't know of a way to print labels from Excel (IS THERE ONE?) so I
assumed I needed to do a 'Mail Merge' into Word in order to print the
mailing labels....

The support folks at Avery only had support for Mac users w/ Word X,
and I haven't been able to follow them to figure out how to get this to
work w/ my Word & Excel 98.
Here's what I've tried without any success:

1) Open a New Document in Word
2) Under 'Tools', select 'Mail Merge'
3) Under 'Main Document', Drop-Down 'Create', select 'Mailing Labels'
and select 'Active Document'
4) Under 'Data Source', Drop-Down 'Get Data', Select from Drop-Down box

'Open Data Source', then go to 'Select A Data File'. From that I
select an excel worksheet I have entitled Avery Labels in which:
Column A:FirstName
Column B: LastName
Column C: Address1
Column D: City
Column E: State
Column F: PostalCode
SO, 6 columns of mailing address info and I have 37 rows worth of
addresses.
5)A 'Microsoft Excel Pop Up Box' appears that says: Named or Cell
Range...choice is 'Entire Spreadsheet'
6) Then a box w/ 'Set Up Main Document' appears and it's the only
choice to select
7) Then a new box opens where a radio button is selected for 'Laser &
Ink Jet', under 'Label Products' : Avery Standard is selected, under
'Product Number' 8660 is selected, Click OK
8) Get a 'Create Labels' box. Click on 'Insert Merge Field'. A
small
blank gray box appears but nothing can be done w/ it (looks like some
sort of error). One thing I tried was to put my cursor in the text
box
beneath it and type in myself:
<<FirstName>><<LastName>>
<<Address1>>
<<City>><<State>><<PostalCode> >
and selecting OK, Close...but that just yields a word doc w/
3 columns of labels that looks like:
<<FirstName>>,<<LastName>>,
<<Address1>>,
<<City>>,<<State>>,<<PostalCod e>>

«Next Record»<<FirstName>>,<<LastNam e>>,
<<Address1>>,
<<City>>,<<State>>,<<PostalCod e>>

Whereas I thought there would be a Word Doc w/ 3 columns filled in w/
my friends name and address info. , not all this coded mumbo jumbo....

HELP, nothing I try seems to work. I have put so much time in to this

that I easily could have hand addressed every envelope, but I'm dying
to understand how to do this.... There has to be a way to get this to
work!!!

Thanks for your time!!!!!!

 

[Daiya Mitchell]

I'm sorry I didn't respond before, I thought something else had gone wrong,
but now that I see:

and selecting OK, Close...but that just yields a word doc w/
3 columns of labels that looks like:
<<FirstName>>,<<LastName>>,
<<Address1>>,
<<City>>,<<State>>,<<PostalCod e>>

«Next Record»

Okay, that is pretty much exactly where you need to be. You have set up the
fields. Now you need to tell Word to actually perform the Merge. On the
Mail Merge toolbar, somewhere there should be an icon for Merge to Document
that you need to click. I'm afraid in Word 98 I'm not totally sure where.

 

[buster2cajun]

THANK YOU DAIYA!!! Baby Rachel is today 23 days old, and today I got a
sheet of mailing labels printed

 

[Daiya Mitchell]

Glad it finally worked out. Now it's late enough to add a really cute
picture.