How do I create labels from a spreadsheet? [closed]

asked 2014-04-18 10:19:18 +0100

challereau@gmail.com
21 ●1 ●1 ●3

updated 2014-06-16 00:18:05 +0100

bencomp

811 ●9 ●20 ●28

I want to print labels from a mailing list i have on a spreadsheet.

I went into File - New - Label and created a label the size i want. But i dont know how to import data into it. In the 'database' section it only gives me the option to select Bibliography...

anybody can help me on this ? that would be awesome...

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 18:15:08.441597

answered 2014-04-18 14:36:30 +0100

Regina

9200 ●8 ●54 ●94

updated 2014-04-18 14:38:18 +0100

The spreadsheet document needs to be registered as database. Therefore you have to generate a .odb database administration file. Goto File > New > Database. Check "Connect to an existing database" and select "Spreadsheet" from the drop-down list. Next. Select your spreadsheet file. Next. Check "Yes, register". Finish. Save the .odb file, for example beside the spreadsheet file.

Make sure, your spreadsheet has columns labels. They will become the database field names.

edit flag offensive delete link

Comments

Great directions. I did it. But what do I do after I get the spreadsheet made into a database? I still need labels.

Theresa ( 2015-04-30 03:10:52 +0100 )edit

The wizard from File > New > Labels now shows your registered "spreadsheet-database". Select it, then select the to be used "table", which actually is a sheet. On the left side you generate the label text. You can write own texts and you can select a database field and insert it into the text with the ← button. Do you read already the help topic "Labels and Business Cards"?

Regina ( 2015-05-01 12:51:58 +0100 )edit

Ok. I have read the relevant help section. What does "Enter the first label mean" in step 6? I selected the first label. I selected all the labels. Nothing happens. If I click synchronize nothing happens. I am sitting here at step six and can't get anything to happen.

IndyDev ( 2019-03-04 19:55:12 +0100 )edit

So I have to copy and paste each entry into the first label. But this only copies the first record of the database onto EVERY label. I want each record of the database to go into each label. How do you do that?

IndyDev ( 2019-03-04 21:44:59 +0100 )edit

OK. See mail merge and labels.

IndyDev ( 2019-03-04 22:07:53 +0100 )edit

add a comment

How do I create labels from a spreadsheet? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 18:15:08.441597

1 Answer

Comments

Question Tools

Stats

Related questions

How do I create labels from a spreadsheet? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-25 18:15:08.441597

1 Answer

Comments

Question Tools

Stats

Related questions

How do I create labels from a spreadsheet? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 18:15:08.441597