Free okwu labeelu bipụtara usoro nke eBay ere ákwà

If you are selling a few items per day on Ebay it might not be worth forking out on a dedicated selling manager that prints the address labels for you. Neither do you want to manually print the address label for each item sold as this can be time consuming and boring.

This free system will allow you to print the address labels in Microsoft Word. It also will print the item(s) na quanities ka ụgbọ mmiri ahụ na mbupu ọrụ, enyere gị eburu, ngwugwu ma biputere na na appropiately.

Iji na-eji usoro a na ị ga-achọ ka Microsoft Okwu 2007 / 2010 / 2013 .

The following will show you how to print address labels in Microsoft Word without the requirement for custom software.

Ihe aga-eme eme na ebay.co.uk

Ihe aga-eme ndị na-esonụ nwere mere ebay.co.uk everytime ga-amasị gị ka ibipụta ọhụrụ okwu aha mmado.

1. Gaa na gị rere ihe ndepụta na eBay ere Manager (My eBay -> N'ire, Mgbe ahụ họrọ rere si ekpe menu)
   
2. Site Ọnọdụ nyo họrọ na-echere ha zigaara
3. Lelee niile checkboxes ọzọ nke rere ihe
4. Click the other drop down list and select download. This will download a csv file. Save the file in a dedicated directory by creating a new one called ‘Ebay Sales’. Save the csv file with today’s date as the filename (dịka. 05.07.2014)

Ihe aga-eme eme Microsoft Okwu

Ihe aga-eme ndị na-esonụ nwere mere Microsoft Okwu naanị otu ugboro.

Melite faịlụ ma họrọ nke labeelu akụkụ.

1. Meghee Microsoft Okwu chekwaa faịlụ dị ka eBay Address aha mmado ke 'eBay ahịa’ ndekọ.
2. Họrọ mailings taabụ si Ribbon banye ogosi ngwaọrụ
3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, nke 10 aha mmado ke A4 mpempe akwụkwọ. When you have chosen the label of your choice click on New Document.
   
4. Ke mailings taabụ pịa Họrọ Recepients -> Jiri ẹdude List
5. Chọta CSV faịlụ ma pịa Mepee.

Tinye adreesị data ka aha mmado

1. Now to add the address and item information to the labels. Click on the mailings tab and choose Rules and add next record if. From the field name drop down list choose item number and click on OK. This ensures that only rows with data in the CSV are picked up in the Labels.
2. Click on Address Block in the Mailings Tab. From the insert recipient name in this format list select the first option ‘Josh’
3. Ke Naanị agụnye mba / mpaghara ma ọ bụrụ na dị iche iche karịa: choose your home country. For me this would be United Kingdom.
4. Uncheck address according to country/destination checkbox. The options you have now selected should be as below.
   
5. Click on Match Fields button and map the field according to the image below.
   
   Pịa ỌDỊMMA mgbe mere ị kwesịrị ị na-ahụ <<Okwu Ngọngọ>> gị aha mmado akwụkwọ. Press enter twice to start a new line leaving a line space.
   

Ịgbakwunye ihe na mbupu data ka aha mmado

1. Na-esonụ bụ na ihe nke ukwu, item name and shipping service on the label. Click insert merge field and choose Quantity and then OK.Press the space bar once to leave a space.
2. Pịa iwu ma họrọ Ọ bụrụ na…Mgbe…Else. From the resulting dialog box, select field name as Item_Number and for comparison choose Not equal to and type x in the Insert this text box. Click on OK. Press the space bar once to leave a space.
3. Click insert merge field and choose Item_Title and press the space bar to leave a space.
4. Pịa iwu ma họrọ Ọ bụrụ na…Mgbe…Else. From the resulting dialog box, họrọ ubi aha ya dị ka Item_Number na tụnyere họrọ Ọ bụghị hà ma na ụdị / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Pịa Fanye jikota ubi ma họrọ Delivery_Service
   

Emepụtaghachi na aha mmado

1. Detuo niile n'ubi ke akpa labeelu na mado ya nke abụọ labeelu
2. Nke abụọ labeelu na-etinye cursor tupu «abia Record Ọ bụrụ» wee pịa iwu ma họrọ «abia Record»
3. Detuo ihe «abia Record Ọ bụrụ na» na mado ozugbo «abia Record Ọ bụrụ» otú i nwere abụọ.
4. Detuo niile n'ubi si abụọ n'ubi niile ndị ọzọ na-aha mmado. You may also want to change the text colors and font size.
   
5. Pịa ịhụchalụ Nsonazụ ịhụ gị aha mmado.
   

Here is the word file that I have created. You will need to download the CSV file with the sold item data from ebay.co.uk If this file works with other ebay sites then please leave a comment below. You might need to re-map the fields to use this file.

Download

If prompted to select the header record delimiters then choose as in the below image and then click on OK. You may be given warnings of missing data, ma ọ bụrụ na otú ahụ pịa OK na nke ọ bụla n'ime ha na.