How do I create name badges by joining "First Name" and "Last Name" fields together?

Follow the instructions below:

 

  1. Preparing the database
    Sample badge
    e.g. Creating name badges using the following Excel file.
    Excel data

  2. Connecting the database
    1. Click [File] --> [Database] --> [Connect...]
    2. Find the directory and select the prepared Excel file.
    Make sure that there is a check mark in the "Header Row Contains Field Names" check box in the Open Database dialogue box.
    Open Database
    If the file being used contains multiple sheets, the Select Table dialogue box appears. Select the sheet that you wish to link to the layout.
    Edit screen

  3. Joining "First name" and "Last name" fields together

    Joining fields allows you to easily arrange the merged object in the layout.

    For example, when you merge "First name" field and "Last name" field without joining fields, the following problems may occur depending on the volume of data.
    If the size of the text object for "First name" field is adjusted to the length of "Michael", an extra space will be inserted between "Ron" and "Becker".
    Sample ImageSample Image
    Meanwhile, if the size of the text object for "First name" is adjusted to the length of "Ron", the size of "Michael" will shrink.
    Sample ImageSample Image
    If the two fields of "First name" and "Last name" are joined, these problems will be solved.
    Sample ImageSample Image

     

    1. Click on the database window (the connected database) to display "Database" on the menu bar.

    2. Click [Database] --> [Connect Fields...]
      The "Define Joined Fields" dialogue box appears.
      Define Joined Fields

    3. Click Add button.

    4. The "Add a Joined Field" dialogue box appears.
      Add a Joined Field

    5. In the "Fields:" list box, select the "First name" field and then click Add button.
      Add a Joined Field

    6. In the same way, select the "Last name" field and then click Add button.
      Add a Joined Field

      In the "Data:" edit box, insert a space between the "[First name]" and "[Last name]" fields.
      Click OK button.

    7. The "Define Joined Fields" dialogue box appears, showing the joined fields.
      Define Joined Fields
      Click Close button.

    To spread a joined field over multiple lines, type "\n".
    "\n" can be entered either by typing in the text or holding down the Ctrl key while pressing the Enter key.


  4. Merging text into a layout

     

    1. Click [Database] --> [Merge into Layout…] or [Insert] --> [Database field].

    2. The "Merge fields" dialogue box appears.
      Select "Text" from the "Merge Type" pull-down menu, and select "[First name] [Last name]" from the "Database Fields that Can Be Merged" list box.
      Merge Field

    3. Click OK button.
      Edit screen
      The two fields of [First name] and [Last name] joined have been merged.

  5. Adjusting the merged data

    Adjust the height, size and position of the merged object.
    Sample ImageSample Image
    Align the text of the object along its horizontal centre by clicking Centering button.
    Sample Image

  6. Editing label object

    In the layout area, type in "VISITOR" above the merged object, and adjust the position, size, and font of the text object.
    Sample Image

  7. Printing

     

    1. Click [File] --> [Print…]

    2. The Print dialogue box appears.

    3. Under "Print Range", select the desired print range.
      Print

    4. Click Print button

    For details on selecting a record range, refer to the following table.

    Print Range Records to be printed
    All Records Print all records.
    Current Record Print the current record.
    Marked/Selected Record(s) Print only the marked records.
    Record Range Print records in the range specified by "From" and "To".

If your question was not answered, have you checked other FAQs?

Have you checked the manuals?

If you need further assistance, please contact Brother customer service:

Related Models

PT-18R, PT-1950, PT-2100, PT-2420PC, PT-2450DX, PT-2480, PT-2700, PT-3600, PT-9200DX, PT-9200PC, PT-9400, PT-9500PC, PT-9600, QL-1050, QL-1050N, QL-500, QL-500A, QL-550, QL-560, QL-650TD, RL-700S

Content Feedback

To help us improve our support, please provide your feedback below.

Step 1: How does the information on this page help you?

Step 2: Are there any comments you would like to add?

Please note this form is used for feedback only.