How to Print Desk Number Labels

How to Print Desk Number Labels

Purpose

In flexible working environments it is often useful for employees to be able to easily identify the specific desk or work point where they are located.  Since OfficeMaps allows every desk to have a unique code, the steps below allow labels or stickers to be easily printed using a Microsoft Word mail merge to label every desk and work point. 


Steps

The data source is the Asset list exported to Microsoft Excel. This is obtained by clicking the OfficeMaps menu then selecting Assets.




Then click Export to Excel.



A number of additional fields are included in the export, so the list can be filtered and saved.
It is then a case of defining the Merge Template. This can be a generic size if the labels are printed A4 then sliced, or it can be set based on standard Avery label pages. Attached to this article is an example of a Microsoft Word Merge Template.

When the Template is opened or a new document created click on Mailings Tab then Select Recipients, Use an Existing List.



In the next dialog, change the drop down filter to 'Excel files' and browse to the downloaded or modified Asset spreadsheet.



Click OK on the next screen




Click on Labels and select the correct label size.

To Add the Barcode to any document template click Insert Merge Field and select the barcode. If it is a clean document it will be the same as adding any other mail merge field except for the QR code.

Select 'qrCodeData' field.



When added, right click the field in the document and choose 'Toggle Field Codes'.




if you want to change the default, right click the field again and you will see a new option Edit Barcode...






Consult this Microsoft document for further definitions:

Once the template is laid out correctly you can click Preview Results to confirm before processing the merge.




To complete, click Finish and Merge.

    • Related Articles

    • Configuring desk reservations

      Requires OfficeMaps Professional For information regarding how to create and manage a reservation please see this article https://help.officemaps.com/portal/en/kb/articles/how-to-create-and-manage-desk-reservations Reservations allow users to select ...
    • Using a Field in AD for Desk Allocation during OfficeMaps Sync

      OfficeMaps has an AD Sync process to add users and associated properties from AD. Information about this is available in the article Sync People from AD. As part of this function, Administrators can specify a field in AD that is used to assign each ...
    • How-to: Create and manage desk reservations

      Requires OfficeMaps Professional For information on how to enable reservations and to configure reservations options, please see this article: https://help.officemaps.com/portal/en/kb/articles/reservations Many users require the ability to reserve a ...
    • Changing your Plan Level/Number of People

      OfficeMaps is licensed in increments of 100 people.  For example a quantity of 2 allows up to 200 staff to be added to your OfficeMaps People directory.  To change the number of people for which your OfficeMaps account is licensed, follow these ...
    • Viewing and Editing Assets in the Desk Panel

      Data Panels provide information about people and objects in OfficeMaps and can be invoked by clicking on the corresponding Data Panel label under the name of the level when using the Location Tree or by selecting an object that appears on a map. ...