I’m posting this here because I’m a complete novice when it comes to Excel.
I will need to print out address labels for a mass mailing. The list of addresses was given to me in an Excel file with the extension “.CSV”. I’ve looked through the Excel Help section for help, but my searches aren’t coming up with much.
Can anyone tell me what the best way is to print out address labels using Excel? I’m using Excel 2004 for the Macintosh.
I’m not an Excel expert, but until one comes along I can suggest using Word instead. It allows you to import the Excel file as a mailing list and then you can use the label templates in Word to line them up automatically for printing. The Word Help file has step by step instructions. Just search for Mailing List.
I’ll second the Word suggestion. Under the File Menu choose Project Gallery. In the Project Gallery on the left is a choice for Labels. Once the Label dialog pops up and you’ve designed the label, hit the Data Merge button at the bottom to import your data. Easy Peasy.
It’s a multi-step process, but here goes.
Assuming that you already have a box of label sheets handy, look at the box to find the label type. It should probably say something like “Avery® 5162”. Keep this handy because you’re going to need it. If you don’t have a box of labels, drop what you’re doing and go get one.
Open your CSV file in Excel and make sure that the first row of information contains the column headings. If it doesn’t, add a row and enter the headings yourself. Ensure that the file is saved to a location you can find later. Close the file.
Start a session in Word. Go to Tools, Letters and Mailings, then Mail Merge…
Use the wizard to guide you through the steps. The system will allow you to select the CSV file where your data is located, then choose which fields you want and how you would like to have them formatted.
Feel free to scream for help if you have any further questions.