Frequently asked questions, tips & tricks

Easy designing of labels. Here you’ll find help, tips and tricks on how to use LabelAssistant Online.

If you don’t find an answer to your question or have a special query about LabelAssistant Online, just send us an e-mail at verkaufsteam-handel@herma.de.

Two speech bubbles in orange and blue with question marks, symbolizing communication and inquiries.

Mail merge instructions

  • Video help "Mail merge"
  • How do I merge documents?

    1. Open LabelAssistant Online, enter the article number in the selected field and press Enter.

    Three options for creating labels: enter the item number, select a design template, or open an existing template.

     

    2. This takes you to your workspace. Click on the “Mail merge” icon (see illustration).

    Button with four blue squares, surrounded by additional icons for various functions such as file upload and QR code.

     

    3. The mail merge assistant now appears. Click on “Here we go”.

    Steps for Data Processing: Upload an Excel file, select the fields, and review the preview. Button 'Get Started'.

     

    4. In the next window, click on “Browse” to find your Excel file for mail merge. Please make sure that this file does not have any hidden columns, hidden rows or merged cells. In the first row, placeholders should be defined for the various columns.

    Field for uploading an Excel or CSV file with a highlighted 'Browse' button. Instructions for selecting a file are visible.

     

    5. When you have uploaded the Excel or CSV file, a window will appear with a list of the columns in your file. Click on the fields to select the ones that you want to add to your label. Click on “Add fields” to add fields as groups of placeholders.

    Tip: In this window you can also choose whether to create fields independently or as barcode or QR code. Click on “Finish up and continue” to print your labels or continue editing them.

    Selection field for labels with options for 'Mail merge 1' and 'Mail merge 2', as well as a button to add fields.

     

    6. Position the placeholder fields on your label as needed – done!

    Two fields outlined in red for mail merge, labeled 'Mail Merge 1' and 'Mail Merge 2', in a document editing program.

     

    Tip:  When you are finished, use the PDF preview to check your labels. Certain text fields might be too small, in which case you will have to adjust your layout. To edit selected fields which you have created, select the “Mail merge” button.

    User interface with options for uploading files and editing fields for a mail merge. 'Edit Fields' button highlighted.
  • Mail merge – Can’t open a file?

    Your Excel file must not contain any columns or rows that are hidden or merged. The first row of the file should have placeholders for the various columns.

Note:

The design software is not optimised for mobile devices.

However, you can open it or send the link to yourself by email. To do this, click on "Send link". In this way you can open the software later on your desktop PC.

Send link