Printing Address Labels

Discuss the spreadsheet application

Printing Address Labels

Postby dleddy » Wed Dec 06, 2017 4:09 am

I have done the following: imported csv file of contacts in Calc, edited as a Xmas Card list, copied and pasted that list into Base table named XmasCardList. I then attempted to create an address label sheet with the following fields: Name, Address, City State, Zip Code using fields from the database table (using Avery 8160 sheet labels). All I get in the preview is some kind of field addressing, instead of the actual data in the fields. I have looked at Help, searched tutorials, tried different approachs. If I cannot find out how to transfer the database table contents to the address label sheet, will need to address all cards by hand. Any help surely appreciated
OpenOffice 4.1.3 on Windows 10
dleddy
 
Posts: 2
Joined: Wed Dec 06, 2017 3:56 am

Re: Printing Address Labels

Postby robleyd » Wed Dec 06, 2017 4:22 am

G'day, and welcome to the community forum.

You may have View | Field names on - try toggling that setting, or press Ctrl+F9 and see if the data are displayed.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.4 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1080
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Printing Address Labels

Postby dleddy » Thu Dec 07, 2017 12:32 am

Thanks for the suggestion but all that does is change the simple field name to a fully qualified name: all labels have the same text. Less important now that I found that the avery website handles the file directly and efficiently-I now have printed labels, a pdf image of the label sheets, and an online project that I can upload revised csv file to. Thanks for your help.
OpenOffice 4.1.3 on Windows 10
dleddy
 
Posts: 2
Joined: Wed Dec 06, 2017 3:56 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot], RPG and 47 guests