Description:

In the LANCOM Cloud-managed Hotspot, generated vouchers can be exported to a *.csv file, among other things. This gives you the option of creating individually designed vouchers for your users, e.g. in Microsoft Word, into which the required hotspot access data is imported from a *.csv data file. This document explains the procedure.


Requirements:


Procedure:

1. Export the generated vouchers in the LMC hotspot portal to a *.csv file.

2. Open Microsoft Word and create a new document.

3. Switch to the Mailings tab and then select Labels under Start mail merge.

Screenshot showing a software interface with various menu options related to document editing and mailing functions, including envelope and label settings.

4. In the next dialog, click the New Label button.

Screenshot of a printer configuration interface displaying options for label types, printer types including dot matrix, laser, and inkjet, and settings for product numbers, letter types, and dimensions.

5. In this example, 16 vouchers are to be printed per page, so define the dimensions as shown in the following figure.

Screenshot of a label configuration interface showing settings for margins, label dimensions, and page orientation details.

6. Select the created label template and then open the Select Recipient → Use an Existing List menu.

An image showing a computer interface for a document editing software with various menu options including Home, Insert, Design, Layout, Mail Merge, and options for managing contact lists and envelopes.

7. Select the exported *.csv file.

8. Make sure that the correct character encoding is selected.

Screenshot of a text encoding configuration menu with options to select encoding type, insert line breaks, allow character substitution, and set document direction, highlighted with a warning that text marked in red will not be saved correctly.

9. You can now modify the voucher in the upper left corner with text and additional data.

In this example:

  • A welcome text is added.
  • With the additional merge field "Network" the network name (SSID) of the hotspot,
  • with the additional merge field "Voucher" the respective password or Voucher ID of the hotspot access,

 are printed on the vouchers. You can also add a graphic to the voucher.

Image showing a computer screen with a document processing interface, displaying options for mail merging and template editing, including labels like Welcome to Hotel Edelwei and Networky repeated across the document.

10. Click on the "Update" button to apply or display the changes for all other vouchers.

11. Then click on the Finish and Merge → Print Documents button.

12. You can now either send the vouchers directly to a printer or print them as a PDF document file.