If you don't already have a Google Drive acccount, find out how to set one up here. If you prefer to do things online then you can also create an Avery sticker sheet using Google documents. Preview Results Click on the ABC symbol to see a preview of the label template.Ĭomplete Merge Either merge to a printer or to a new document. Once you’ve pressed ‘OK’ the fields will appear on the document.įilter Recipients This allows you to filter out any recipients by each category - for example if you only want labels for recipients in a particular city.
Select each of the fields you want to include, hitting enter in between so that they appear like this: Once you click ‘OK’ another window will open to edit the label.
Click ‘OK’ when it asks about security, and the ‘Cell Range’ should be Entire Worksheet. Select Recipients List Click ‘Get List’, then choose ‘Open Data Source’, now you can choose the excel file with the addresses. Select Document Type Select ‘Create New’ and then ‘Labels’.Select which printer you have, and choose the labels you are going to print on using the drop down menu. A small Mail Merge Manager window will open: Go to ‘Tools’ and select ‘Mail Merge Manager’. Once your spreadsheet is ready close it and open a word document. Then you need to copy and paste each line of the addresses into the relevant columns - repeat this for each address that you need to print a label for. The first row should contain the titles for each section: Name, Street address, City, Postcode. However, if you have issues with it (looking at the comments below the download will give you an idea of some peoples problems), or you are using a Mac, then you can template your eBay order address into an Avery sticker sheet using Microsoft Word.įirst of all you will need to set up an Excel spreadsheet with all of the addresses from your ebay orders - this is the most time consuming and tedious part of the process. If you use a PC then you can download the Avery Wizard for Microsoft Office. We investigate two different methods (using Microsoft Word and Google Documents) to template your eBay order addresses to an avery sticker sheet. While this may seem like the perfect solution, it is important to know exactly what's involved before you start.
By using an Avery sticker sheet (also known as address labels) you can print a whole page of addresses on to labels that are ready to peel off and stick on to your parcels. If your eBay orders are piling up then you’re probably looking for a simple and efficient way to label your parcels to send out.
0 kommentar(er)
