Mac Forum / Applications / MS Office / June 2005

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!!!!!!