TD-4100N
![]() |
FAQs & Troubleshooting |
![](/g/b/img/product/lptd4100neas.jpg)
TD-4100N
Date: 12/06/2023 ID: faqp00001048_003
How do I create name badges by joining "First Name" and "Last Name" fields together? (P-touch Editor 5.x for Windows)
For TD-4T/TJ-4T series:
To use P-touch Editor, download and install “Printer Driver for P-touch Editor” from the [Downloads] section of this website.
Follow the instructions below:
-
Preparing the database
e.g. Creating name badges using the following Excel file
-
Connecting the database
-
Click on [File] - [Database] - [Connect...]
<Using Express mode as an example>
-
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 dialog box. Click the "Next" button.
If the file being used contains multiple sheets, this dialog box appears. Select the sheet that you want to link to the layout.
-
Click on [File] - [Database] - [Connect...]
-
Joining fields - Joining "First name" and "Last name" fields together.
- Click on the database window (the connected database) to display "Database" on the menu bar.
-
Click on [Database] - [Connect Fields...]
-
The "Define Joined Fields" dialog box appears. Click the "Add" button.
-
The "Add a Joined Field" dialog box appears. In the "Fields:" list box, select the "First name" field and then click the "Add" button. In the same way, select the "Last name" field and then click the "Add" button.
-
In the "Data:" edit box, insert a space between the "[First name]" and "[Last name]" fields then click the "OK" button.
-
The "Define Joined Fields" dialog box appears, showing the joined fields. Click the "Close" button.
To spread a joined field over multiple lines, type "\n". It can be entered either by typing in the text or holding down the Ctrl key while pressing the Enter key.
-
Merging text into a layout
-
Click on [Database] - [Merge into Layout…] or [Insert] - [Database field].
-
The "Merge fields" dialog 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. Click the "OK" button.
-
The two fields of [First name] and [Last name] joined have been merged.
-
Click on [Database] - [Merge into Layout…] or [Insert] - [Database field].
-
Adjusting the merged data
-
Adjust the height, size and position of the merged object. Align the text of the object along its horizontal center.
-
Adjust the height, size and position of the merged object. Align the text of the object along its horizontal center.
-
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.
-
In the layout area, type in "VISITOR" above the merged object, and adjust the position, size, and font of the text object.
-
Printing
- Click on [File] - [Print…]
-
The Print dialog box appears. Under "Print Range", select the desired print range and click the "OK" 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. Record Range Print records in the range specified by "From" and "To".
PT-1650, PT-1950, PT-2100, PT-2430PC, PT-2700, PT-2730, PT-3600, PT-9500PC, PT-9600, PT-9700PC, PT-D600, PT-E550W, PT-P700, PT-P710BT, PT-P750W, PT-P900W, PT-P910BT, PT-P950NW, QL-1050, QL-1050N, QL-1060N, QL-1100, QL-1110NWB, QL-500, QL-550, QL-570, QL-580N, QL-650TD, QL-700, QL-720NW, QL-800, QL-810W, QL-820NWB, RJ-2030, RJ-2050, RJ-2150, RJ-3050, RJ-3150, RJ-4030, RJ-4040, RJ-4230B, RJ-4250WB, TD-2020/2020A, TD-2120N, TD-2125N, TD-2125NWB, TD-2130N, TD-4000, TD-4100N, TD-4410D, TD-4420DN, TD-4420TN, TD-4520DN, TD-4520TN, TD-4550DNWB, TD-4650TNWB, TD-4750TNWB, TJ-4020TN, TJ-4420TN, TJ-4422TN
If you need further assistance, please contact Brother customer service:
Content Feedback
Please note this form is used for feedback only.