How do I create a database from which to print envelopes for Christmas Cards
Hello,
the most simple method sufficient for
a) a small number of addresses
b) private purposes and non-regular usage
- Create a calc spreadsheet with columns “name”, “firstname”, “street”, “zip code”,“city”,“state” (and whatever may be required to correctly address within your country)
- Save the spreadsheet (e.g.
ChristmasAddresses.ods) File -> Wizards -> Address Data Source ...- Select
Other external data source - Click button Next > and button Settings (next pane)
- Select *Database type:
Spreadsheetand Click button Next > - Browse for the sheet you created before and click button Test connection
- Click button Finish
- Optional (but recommended, if you don’t want to do later): Perform the Field Assignment by clicking the related button
- Click button Next >
- Deaktivate option
[ ] Embed this address book definition into the current documentand provide a location (file name) for the database file (e.g<whatever_your path_is>/ChristmasAddresses.odb - Check option
[x] Make this address book available to all modules in LibreOfficeand provide an Address book name (e.g.ChristmasAddresses) - Click button Finish
The database now is selectable in Writer when using Insert -> Envelope
This procedure has been tested on:
Version: 7.0.3.1,Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US,Calc: threaded
Hope that helps.