how to print address labels from excel spreadsheet on mac

Give this name to the top column and then fill in the relevant information in the respective columns. If you're intending to print labels with a label maker for electricians, then assign the relevant column heading. Each column should be given a different name like name, address, and city. This information should be organized into columns. Creating Labels With Excelįirst, create a spreadsheet having information like name, address, city, and area with the zip code. Your label had successfully been created and is ready to be printed. Now click the 'create label' option to save the label. The last step is to save the labels in google docs. Now above the top left corner of the box in which you are inserting information, there is an option of 'add a merge field.' Select that option and choose the last option of 'zip code.' Fill in the information according to the layout provided. In the drop-down menu that appears, select “Labels.The layout will give various options like name, address, city, or area. Next, head over to the “Mailings” tab and select “Start Mail Merge.” Go ahead and save your list and let’s head over to Microsoft Word. Once you’re finished, your list should look something like this: Once you’ve finished creating the headers, go ahead and input the data.

RELATED: How to Create and Print Labels in Word You can even insert images in the mailing labels if you want, but that step would come later in Word. This is the standard information you’ll find on mailing labels. Our list will include the following headers:

To properly illustrate the steps, we’ll go with a personal mailing list in this example. Also, if your list is for companies and not individual people, you can omit the “First Name” and “Last Name” header and just go with “Company Name” instead. Titles are always nice, but it’s important that you know which title a person goes by before creating the labels. Which headers you include depends on which information you plan to use in the mailing labels.

How to print address labels from excel spreadsheet on mac