PDA

View Full Version : MS Excell



Peter H
28-08-2002, 11:17 AM
I have a list of members in an Excell worksheet. Column a - name - b -address - c - district etc. Also have Avery label maker. Part of Word 97. Any method of copying the names etc into the labeling program?
Bye

godfather
28-08-2002, 11:37 AM
Yes.
You can use an Excel sheet as the input data for maimerge and labels.

Where you have to specify the data in Word 97, there is a drop down box for .xls

It works, I have used it. Dont have 97 loaded now, but try it anyway.

Susan B
28-08-2002, 11:40 AM
Word uses a table for its mail merge data so if you go to word and use the mail merge wizard you can just copy your excel data and paste it into the word table that is created with the Data Source>Get Data>Create Data Source.

If you need more clarification just ask, as I don't want to explain everything if you already know it.

Susan B
28-08-2002, 11:42 AM
Actually, using Excel as your data source as godfather has advised, is much better in my opinion.

Peter H
28-08-2002, 12:03 PM
Thanks GF & Susan. Saves me using up the few grey cells I have left.
Bye
Peter