Brother QL-500 User Manual
CREATING LABELS
54
Using P-touch Editor with Other Applications
3
Click
to print the label.
How Microsoft Word data is added to the Label List
A new record is automatically created and the text in the selected data is added to the following
fields.
• The current date is added to the Date field.
• The first line is added to the Title field.
• All remaining lines are added to the Body field.
fields.
• The current date is added to the Date field.
• The first line is added to the Title field.
• All remaining lines are added to the Body field.
Microsoft Excel
You can start the P-touch Add-In and copy the highlighted data directly onto a label from Microsoft
Excel. The highlighted data is copied as text and automatically added to new records created in the
Label List. The Title, Body and Code fields of the new record are then merged into a new label
layout, which is displayed in the Add-In Preview window.
Excel. The highlighted data is copied as text and automatically added to new records created in the
Label List. The Title, Body and Code fields of the new record are then merged into a new label
layout, which is displayed in the Add-In Preview window.
Creating a label using data from Microsoft Excel
1
Open a Microsoft Excel worksheet and select the data you wish to place on a label. To
select the data, highlight the text.
select the data, highlight the text.
To edit or customize the text or label layout, click
.
The full P-touch Editor screen appears and you can edit the label.
• Uncheck the "Label List" checkbox in the Add-In Preview window when you do not want to register the
data in the Label List.
• The data is copied onto a label formatted with the default Layout Style. To change the Layout Style, click
to open the full P-touch Editor screen and edit the layout or apply a different Layout Style. Refer to
“Creating Labels Using a Layout Style and Data from the Label List” on page 47 for details.