csv file now so that the next time you do all this you won't accidentally select the old file. Select your printer from the dropdown, and select 'Print' (be sure your label sheets are loaded in the printer first). When it opens (hopefully in your browser), you should see a print dialog box. A box should pop up with 'PDF created' in it. Click the green 'Complete Merge' button.Ĭlick 'Print'.Drag the four fields over to the box on the right side (COMPANY, ADDRESS 1, ADDRESS 2, CITY-STATE).In the browser, un-check 'Print this row of data' (this will keep you from printing out your headers column).csv file) and click on your file: (ADDRESS LABELS FOR INVOICES - Sheet 1.csv). Browse to your Downloads folder (or wherever you saved your. The 'Import Data (Mail Merge)' box in the left column should slide open. Click on the large label in the middle of the page.

On the left side of the next screen, click 'Import Data (Mail Merge)'.Now click the plain label with just 'Name / Address / City State Zip Code' on it. If a form window pops up, fill out the form (you can use fake info).On the right side of the page, click 'Labels'.(Use Firefox to do this part.) Open Firefox. This is the file you'll import into Avery. The file should now be saved in your Downloads folder as 'ADDRESS LABELS FOR INVOICES - Sheet 1.csv'. In your spreadsheet view in your browser (still in Google Docs), click the 'File' menu and click 'Download as / Comma Separated Values'. Your data should now be sorted alphabetically.ĭownload your data as a. Select 'sort by COMPANY' and be sure that 'A -> Z' is selected. In the 'Data' menu, select 'Sort range.'. To sort your label data, click the rectangle in the upper left corner of your spreadsheet (this will select the entire spreadsheet). Your changes will be saved automatically. Login with your gmail login if you're not already logged in.Ĭlick the 'WORK' folder, then click 'ADDRESS LABELS FOR INVOICES' file (green icon). In Chrome browser (ideally - use Firefox if you don't have Chrome) go to. csv file into the Avery label maker site (not using Excel) Edit and sort your labels file in Google Docs (not in Excel).Word also has a Step by Step Mail Merge Wizard (found under the Mailings tab > Start Mail Merge button), which basically walks you through the process above.NOTE: DO AVERY LABEL IMPORT STUFF IN FIREFOX - I DON'T THINK THE AVERY SITE IS COMPATIBLE WITH CHROME In addition to letters (which can be any sort of document, including certificates and coupons), you can choose emails, envelopes, labels, or directories as the document type. Pipojte jej k poítai PC nebo Mac® a pouijte software DYMO label pro tvorbu títk s individuálními styly písma i grafikou s moností natení pro mobilní zpracování a tisk. Repeat this for other types of documents you'd like to use mail merge for.

How to do mailing labels on a mac