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).NOTE: DO AVERY LABEL IMPORT STUFF IN FIREFOX - I DON'T THINK THE AVERY SITE IS COMPATIBLE WITH CHROME
0 kommentar(er)
