How do I export addresses from timeSensor LEGAL for mailing?

This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com.

General

This article describes two ways to export addresses from timeSensor LEGAL.

Copy/Paste

The easiest way is to select the desired data records in the address management of timeSensor LEGAL and select "Copy" with a right click. This puts the addresses on the clipboard and they can be pasted into Excel with "Paste".

Export

The second possibility is to use the export dialogue. Select the desired data sets and choose the command "Export -> Export data sets" in the "Tools" menu. The export dialogue of the 4D database opens.

Select the table "Addresses" in the menu (1).
By default, all fields are copied into the field list (4).
We do not want this, so first empty the field list by clicking on the button with the double arrow pointing upwards (3).
Now select the desired output format for the export file. In our example, you export the data as a text file, which is why we leave the menu under Format (7) set to "Text". Which format you choose here depends on the format in which you need the data in the target software. You may have to experiment a little here!
Under (7) you can select further export details, for example whether the data should be exported with a column header.
Now select the fields you want in the scrollable area (2). These appear in the field list (4)
If everything is correct, you can save the format to your hard disk with the Save button (5). This will save you having to rebuild it the next time.
Start the export by clicking on Export (8).

Import in Excel

Importing into Excel depends on the version of Excel you are using:

Select a new worksheet and in the "File" menu the "Import" command.
Select "Text file
Open the previously exported file
Select "Add a delimiter".
Select "Tab stop" and "Finish".
Now you can import the data into your spreadsheet.