Ask Your Question

Labels from spreadsheet [closed]

asked 2017-01-18 07:58:43 +0200

wftomlin gravatar image

updated 2020-08-02 12:44:40 +0200

Alex Kemp gravatar image

I followed these directions: "The spreadsheet document needs to be registered as a 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.

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

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."

What gets printed is the field name inside <>, NOT the actual data in the field, i.e.

<fname> <lname> (instead of Frank Tomlin)
<street> (instead of 123 Main St)
<city> <st> <zip> (instead of Chicago IL 61616)

What am I doing wrong?


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 12:44:48.715290

2 Answers

Sort by » oldest newest most voted

answered 2017-01-18 12:43:40 +0200

m.a.riosv gravatar image

Maybe Menu/View/Field names [Ctrl+F9]

edit flag offensive delete link more

answered 2017-01-18 17:20:59 +0200

wftomlin gravatar image

OK. The instructions left out the LAST step, which was to do a Tools > Mail Merge Wizard...

Works fine.

Thanks again.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-01-18 07:58:43 +0200

Seen: 6,398 times

Last updated: Jan 18 '17