cannot find list in excel 2000

[Guest]

Hi
I am trying to make list in excel 2000. But am not able to find the option.
I have also tried looking in the toolbar under View, but do not see any list.
I want to create list and then use in mail merge for word 2000.
Would appreciate any help.
Regards
Tanu

 

[Gord Dibben]

Tanu

Excel 2003 introduced the "list" function.

You will have to manually type in your information or import from another
source.

What is it you want to be in your list?

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033


Gord Dibben Excel MVP

 

[Dave Peterson]

You mean like Data|list|Create list???

This was added in xl2003.

But you don't need to make it an excel list. Just put the data in excel.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

 

[Guest]

Hi Tanu. Just put your labels - name, street, city, state, zip, etc. - in
row 1 of a blank spreadsheet and enter your data. When you get data in
mailmerge, select that file. HTH