DH Templates

word or excel?

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!

Public Comments

1. Excell for sure!
2. Excel, word cannot do all that.
3. 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.
4. Your Best Choice would be WORD.
5. 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!