Using Microsoft Works to print address labels
- Start with Microsoft Works
- In "Choose a category" select "letters and labels" and within that select "return address and labels"
- This then fires up Works Word and asks what kind of labels.
- Select "Mailing labels" (which requires a data source)
- Choose how many labels to a page. Chose 3 x 6 (3 across by 6 down)
- You are then prompted to select data. Choose "another type of file".
- By default you are prompted to choose a Works database. Other choices are excel and CSV (more later). Tried excel but could not make it work. Tried database and CSV. Both worked fine.
- If you chose database, there are quite few bits of theory needed to follow what you are doing and why. A specialist subjects for 20+ years. It is bit over the top for labels.
- Chose CSV. It stands for Comma Separated Values.
If you take this as an example. It shows how a couple of rows of a spreadsheet appear:-
Fuller Andrew Vice President, Sales 1235 Main St. Tacoma 14222 USA Leverling Janet Sales Representative 1235 Elm St. Kirkland 14222 USA
As CSV it appears all compressed, separated with commas:-"Fuller","Andrew","Vice President, Sales","1235 Main St.","Tacoma",14222,"USA" "Leverling","Janet","Sales Representative","1235 Elm St.","Kirkland",14222,"USA"
- So need to interrupt the labels in step 6 above.
- Go back to the Spreadsheet and save it as a CSV.
- Resume from step 6 and choose CSV.
- Follow the prompts to complete the label.
- Check with print preview that all looks fine.
- Save file as Works Document (.wps)
LAST UPDATED: 02 February 2018 (Bluetooth File Transfer)