What is the best way to maintain a mailing list in Excel...?

Question

...but then to convert it to a Word document to plug into one of their provided label formats. I have a list that I need to keep alphabetized, but needs to be labeled and mailed once a quarter. I don't know why I can't for the life of me figure out the best way to do this. I'm pretty good with a computer, but I can't remember how to do this - it's frustrating...

Thanks for your help... :)

Answer 1

Easy. Once you do it once it's super simple. You have to do a mail merge. Keep all parts of the address in different cells in excel, separate name, street, city and state, zip. Then open a word doc and under tools, letters and mailings, you'll see mail merge. It walks you through the process of creating a label and you can choose to import the data for the labels from another document. Use word help to get the details.

Answer 2

I keep mine in Outlook as a Contacts list. When I need to do a mail merge I just direct it to my Outlook. I can also export the list into Excel if needed.

This is very similar to the option above of using a column for each property (ie. name, street address, city)

Answer 3

create a query to find a record of email.
after finding it, you can insert a row or delete a row
you can keep a backup by print it as pdf

Answer 4

I dunno if this helps, but you can definitely alphabetize in word.

Also, in the future it helps to tell people what version of excel/word you're using because the way to do things might change from version to version.