How to do a Merge in order to print mailing labels

[buster2cajun]

HELP
I'm working on a Mac iBook running on OS 9.2.
I have Microsoft Word 98 and Microsoft Excel 98.
I purchased Avery Clear Mailing Labels which say "use 8660 software
layout". Each 8.5 x 11 sheet has 3 columns and 10 rows for a total of
30 labels.
I have an Excel Worksheet entitled
AveryLabels.xls in which:
Column A:First
Column B: Last
Column C: Street
Column D: City
Column E: State
Column F: ZIP
SO, 6 columns of mailing address info and I have 46 rows worth of
addresses.

Will I be able to print the first 30 addresses on one sheet of labels
and the remaining 16 on a second sheet?

I presume I need to do some sort of 'Mail Merge' and I'm trying it in
Word under Tools and then under Mail Merge but nothing seems to work.

Please describe how I can accomplish my task. This is important
because I have a baby due on Sunday and want to have the mailing labels
printed out for announcements
THANK YOU FOR YOUR HELP!!!!

 

[Daiya Mitchell]

Can you describe exactly what you are doing and exactly what isn't working?
I no longer have Word 98 installed so cannot try it out. I know there have
been improvements to Mail Merge since Word 98 but think this simple task
should work fine.

Congrats on the baby, best of luck!

 

[buster2cajun]

Thanks Daiya...I really need help now, beautiful little Rachel was born
since I wrote with my question, and it's time to mail photos to friends
and relatives.
The support folks at Avery only had support for Mac users w/ Word X,
frustrating because I'm a Mac user w/ Word 98. Here's what I've tried:
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>>,<<PostalCode>>

«Next Record»<<FirstName>>,<<LastName>>,
<<Address1>>,
<<City>>,<<State>>,<<PostalCode>>

Whereas I thought there would be a Word Doc w/ 3 columns filled in w/
my friends name and address info.

HELP, nothing I try seems to work. I have put so much time in to this
that I easily could have hand addressed every card. There has to be a
way to get this to work!!!

Thanks for your time!!!!!!