word or excel?

Question

If I need to make a list of names+address, where should I put info in work OR excel?
1. I would need to make the list in alphabetical order, so I need to be able to sort it from a-z.
2. I would need to input the names+address into my avery label template ready for printing
Help!
I guess 2 is less important bcuz I would always copy & paste....maybe!

Answer 1

Excel would be better choice.

Excel advantage(s)
Allows Sorting ( based on alphabetical order, zip or state - depends on how you input your excel sheet )
Some basic analysis - For example you want to find out how many contacts are in "NY" state

However, if you have Outlook or Outlook Express, I would recommend using that. They have "Contacts", where you can enter contacts and especially designed for handling contacts.

Answer 2

Use Excel for this
In Cell A1 Put the First Name
In Cell B1 Put the Last Name
In Cell C1 Put the Street
In Cell D1 Put the Town
In Cell E1 Put the State
In Cell F1 Put the Zip

Then start in row 2 for the next Person and repeat these steps down the sheet.

To sort the list, just select all, click data, then click sort.

You can easily import this into Avery Design Pro if that is what you are using.

Be careful not to put any spaces before or after any data in each cell.

Avery doesn't work well with leading or trailing spaces.

If your using Design Pro here are some steps I use to import.

Click Database
Click Open
Click ODBC
Click the "Machine Data Source" TAB
Double Click "Excel Files"
Choose the File to Import
File.xls
Choose the sheet within the file
Sheet1


GoodLuck!

Answer 3

Excell for sure!

Answer 4

Your Best Choice would be WORD.

Answer 5

Excel, word cannot do all that.