A comma separated values list is a file format in which data is saved from a spreadsheet and can be merged to create address labels. Microsoft Excel has the capability to save spreadsheets as comma separated lists, which then can be merged into Microsoft Publisher to create address labels. Once the addresses have been entered into Excel, the merging feature combines the two file formats. This eliminates having to enter each address separately and saves time creating labels.
- Skill level:
- Moderately Easy
Other People Are Reading
Things you need
- Microsoft Publisher
- Microsoft Excel
Open a new spreadsheet in Microsoft Excel. Create the following column headings: First Name, Last Name, Address 1, Address 2, City, State and Postcode. Fill in the information in the Excel rows.
Select "Save As" from the Excel "File" menu. Choose the .csv file extension from the "Save File As" drop-down menu, label the Excel file and save it to the desktop. Close the Excel file.
Open Microsoft Publisher. In the opening catalogue, select "Labels" and then "Mailing Address" labels. Choose the size of the address labels, then click the "Start Wizard" button.
Follow the instructions in the "Label Wizard" to add a colour scheme and design, then click "Finish Wizard."
Select "Mail Merge" from the "File" menu, then click "Open Data Source." Select the Excel file with the address information. Add the fields (column headings from the Excel file) to the mailing labels and click "Merge."
Merge the fields. The address labels should now contain the information from the Excel file.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for