PT-D450
![]() |
FAQs & Troubleshooting |
![](/g/b/img/product/d450euk.jpg)
PT-D450
Date: 21/06/2023 ID: faqp00001048_003
How do I create name badges by joining the "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.
-
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 dialogue box. Click the [Next] button.
If the file being used contains multiple sheets, this dialogue box appears. Select the sheet that you wish to link to the layout.
-
Click on [File] - [Database] - [Connect...]
-
Joining fields - Joining "First name" and "Last name" fields together.
Joining fields allows you to easily arrange the merged object in the layout.- Click on the database window (the connected database) to display "Database" on the menu bar.
-
Click on [Database] - [Connect Fields...]
-
The "Define Joined Fields" dialogue box appears. Click the "Add" button.
-
The "Add a Joined Field" dialogue 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" dialogue 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" 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. 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 centre.
-
Adjust the height, size and position of the merged object. Align the text of the object along its horizontal centre.
-
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 dialogue 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-1230PC, PT-18R, PT-1950, PT-2100, PT-2430PC, PT-2700, PT-2730, PT-3600, PT-9500PC, PT-9600, PT-9700PC, PT-9800PCN, PT-D450, PT-D600, PT-E550W, PT-H500, PT-P700, PT-P710BT, PT-P750W, PT-P900W/P900Wc, PT-P950NW, QL-1050, QL-1050N, QL-1060N, QL-1100/1100c, QL-1110NWB/1110NWBc, QL-500, QL-500A, QL-550, QL-560, QL-570, QL-580N, QL-600, QL-650TD, QL-700, QL-710W, QL-720NW, QL-800, QL-810W/810Wc, QL-820NWB/820NWBc, RJ-2030, RJ-2050, RJ-2140, RJ-2150, RJ-3050, RJ-3150, RJ-3230B, RJ-3250WB, RJ-4030, RJ-4040, RJ-4230B, RJ-4250WB, TD-2020/2020A, TD-2120N, TD-2125N, TD-2125NWB, TD-2130N, TD-2135N, TD-2135NWB, TD-4000, TD-4100N, TD-4210D, TD-4410D, TD-4420DN/4420DN(FC), TD-4420TN, TD-4520DN, TD-4520TN, TD-4550DNWB / 4550DNWB(FC), TD-4650TNWB, TD-4650TNWBR, TD-4750TNWB, TD-4750TNWBR, TJ-4005DN, TJ-4020TN, TJ-4021TN, TJ-4120TN, TJ-4121TN, TJ-4420TN, TJ-4422TN, TJ-4520TN, TJ-4522TN, TP-M5000N
If you need further assistance, please contact Brother customer service:
Content Feedback
Please note this form is used for feedback only.