How do I export addresses from timeSensor LEGAL for mailing?

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.


  1. Select the table "Addresses" in the menu (1).
  2. By default, all fields are copied into the field list (4).
  3. We do not want this, so first empty the field list by clicking on the button with the double arrow pointing upwards (3).
  4. 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!
  5. Under (7) you can select further export details, for example whether the data should be exported with a column header.
  6. Now select the fields you want in the scrollable area (2). These appear in the field list (4)
  7. 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.
  8. Start the export by clicking on Export (8).

Import in Excel

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

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




    • Related Articles

    • How do I import addresses from Excel into timeSensor® LEGAL?

      If you want to import addresses from Excel into timeSensor LEGAL, you can do it in just 5 steps . Prepare addresses in Excel and save as tab-delimited text (.txt). In timeSensor LEGAL, select Addresses - Clients - Tools in the area bar and select the ...

    • How do I export the booking data from timeSensor LEGAL?

      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 timeSensor LEGAL allows you to export your booking data to a booking file. This booking file can ...

    • How Do I Export my TSL Accounting?

      To export your accounting from timeSensor LEGAL, go to "Special", "Accounting", then select "Export". Select your export options in the "Export Transactions" window: The Period from menu lets you select the start date for your export. The Period ...

    • Does timeSensor® LEGAL support the vCard format?

      This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com. timeSensor LEGAL supports the import and export of addresses in vCard formats 2.1 and 3.0. Importing vCards ...

    • How do I export deadlines and/or dates?

      This article has been machine translated. If you find any errors, we would be grateful if you could report them to translation@timesensor.com. The background task Deadlines exports the data entered in the Deadlines/WV or Calendar window in iCal ...