Label printing with Vertec

On an address list directly in Vertec

To print labels directly to an address list in Vertec, follow these steps:

1. Create a new Office report in the Settings > Reports & Scripts > Report Templates folder.
2. Register him to the class Adresseintrag, single & list report.
3. On the Report Definition page, insert the following code:

   class Adresse(Table):
       businessclass = "Adresseintrag"

4. Create a Word template and define the quantity of columns you need for your label template in the Layout menu.
5. Now insert a table with one row and one column.
6. In the cell with the right mouse button > Table Properties > Row define the height according to your labels and select row height Genau.
7. In the table cell, type adresstext and insert a (blank) comment via Insert > Comment.

   

8. Now select all (Ctrl&A) and use Insert > Highlight to insert a highlight with the name bndMain.
9. Save the Word template and load it into the Vertec report template:

   

10. From now on, you can print the labels directly from the Printed menu in any Vertec address list.

For more detailed information about Office Reports and other ways to Report Registration (direct link, drop to activity, etc.), see the corresponding articles.

Mail merge in Word

1. In Vertec, select the list of addresses you want to print.
2. Go to the list settings of the address list (button at the bottom right). Now create a new column and mark it. In the Expression field, type adresstext (case sensitive). You will now have a new column with the preformatted addresses in the list.
3. Export the list of addresses to Excel using the built-in Excel export button (bottom right button). You can then delete the previously created new column in the list settings if necessary.
4. In Excel, delete the top two rows so that the column headings are the first row.
5. Save the Excel list in a location where you can find it later.

Now you can create the usual mail merge in Word and load the saved Excel list as a recipient list:

1. Go to the “Shipments” tab, click on “Start Merge...” and select “Merge Wizard with Step-by-Step Instructions...”.
2. The Mail Merge Wizard opens on the right side of the screen. Select Labels.
3. Click on “Next: Document starts”.
4. Under “Label Options” you can select the appropriate label template. Then click on “Next: Select Recipient”.
5. For recipients, select “Use existing list”. In the middle part of the window, click on “Browse...” and select the Excel list stored above.
6. A message appears. Select “Sheet1$” and “First row contains column headers” (default). In the list that appears, you can pre-process the mail merge recipients if necessary. Then click OK.
7. Click Next: Arrange your labels.
8. Move the mouse pointer to the first label in the top left (it is the only label that is blank; all others say “Next Record”).
9. On the right, select More items, select Addresstext, and then click Close.
10. Now click on the button “Update all labels”. The command “Addresstext” will be inserted into all labels.
11. Now you can call up the labels via “Next: Preview your labels”.
12. If everything is OK, click “Next: Exit Merge”. You can now print the labels.