Ask Your Question
0

Labels from spreadsheet

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

wftomlin 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?

Thanks

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

m.a.riosv gravatar image

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

edit flag offensive delete link more
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 495 times

Last updated: Jan 18