Importing the Contact Data | Brother QL500 instruction

Importing the Contact Data

The CSV format files and Outlook® Contacts data can be imported and used as P-touch Address Book contacts.

Importing the contact data in CSV format

1 Click [File]-[Import]-[CSV File].

The [Open] dialog box appears.

2 Select a file to be imported and click

.

The [Stop Signal Replacement] dialog box appears.

3 Select [Original File Conversion Stop

signal] and click .

When the [Make Field Name the First] is checked, the first line shows the field names.

The [Fields to Import] dialog box appears.

4 Assign [CSV/Outlook Fields] to [Address

Book Fields] and click .

Every CSV file field is imported, even if the same field is not included in the Address Book contact.

The Contact data are displayed in Record View.

36	Importing the Contact Data

Introduction

Creating Labels (For Windows)

Creating Labels (For Macintosh)

Appendix

Image 36

Brother QL500 manual Importing the Contact Data, Importing the contact data in CSV format

Contents

Software Users Guide Contents How to use the Users Guide Html Manual Symbols Used in this Manual Setup & Operation Guide Quick Start GuideAbout This Manual Manual Structure Label Creation Overview From Label Creation to PrintingChoose the type of label you want to create Create and print a label using P-touch Editor Create and print a label using P-touch Address BookCreate and print the label After creating a template How to Use P-touch Editor Starting P-touch EditorSelect an option in the Startup dialog box and click Layout window Creating an Address Label Printing a Label Print Options and label cutting Saving a Label Opening a Label FileClick File-Save As Click File-Open Creating Different Types of Labels Using the P-touch Editor Help Opening the Help filesTouch Editor Help window Starting P-touch Editor Printing a Help description Select the range of topics to be printed ClickSpecify the Printer item and click Using the Label List Creating Labels EfficientlyOpening the Label List Click File-Database-Label List Switching the Label List view „Record View„Form View Entering data „What is a Layout Style? „When is it useful to use a Layout Style?Layout Styles „Changing the Layout Style for each DK Roll „Using a Layout Style to create labels Return to the Layout window to check the labels „Creating and registering a new Layout Style Click File-New 11Select the layout style you have created Click Printing labels from the Label List Click in the Print propertiesChoose the Print Options Print Range, specify the records to be printed Using external database files Prepare a database fileStart the P-touch Editor and specify the label size Click File-Database-Connect Specify how the file will be opened, Click Click Text 10Select Bar Code 11Click in the Print properties Add-In settings Creating Labels with Other Applications Creating labels using Microsoft Word Microsoft WordToolbar in the Add-In Preview window How to add the Microsoft Word text to a label list Creating labels using Microsoft Excel Microsoft Excel How to add the Microsoft Excel text to a label list Microsoft Outlook On the Microsoft Outlook standard toolbar, click How to add the Microsoft Outlook text to a label list „When importing data from the Contacts window„When importing other than Contact information How to Use the P-touch Address Book Starting the P-touch Address Book Menu bar Text toolbarLayout style selection view Contact list combo box Creating a New Contact Click File-New Contact. Or, clickEnter data for each item New Contact form toolbar Importing the Contact Data Importing the contact data in CSV format Editing the Contact Data Importing the Outlook contact dataClick File-Import-Outlook Contacts Click File-Edit Contact. Or, click Printing the Label How to Use P-touch Transfer Manager & P-touch Library Starting up P-touch Transfer Manager Explanations of the Icons Folder view Transferring label templates from the PC to the printer Select the printer to transfer data toDrag the transfer data to the folder you just made Select the data or folder you want to Transfer,then click Click Yes Creating and transferring a new message QL-650TD only Backing up label templates Deleting all the printer dataSelect the printer to back up from, then Click Right click the printer, then select All Delete Changing printer settings from the PC Change settings as necessarySelect the printer, then click Click Set Starting up the P-touch Library Opening and editing dataPrinting labels Select the data you want to edit, then click Searching labels Click Begin Search Procedure for Creating and Printing Labels OverviewChoose the label you want to create Entering text Î Creating labels Î Using the P-touch Editor Starting the P-touch EditorDouble-click the P-touch Editor 3.2 folder Layout Window Print ToolbarDatabase Toolbar Layout Window Property Dock Click on in the Property dock Select Standard Address Label Printing Options Click on in the print bar„Copies & Pages „Roll Setting „Halftone/Color„P-touch Editor How to use the Users Guide Html Manual Installing the Users Guide Html ManualOpening the Users Guide Html Manual „Summary User’s Guide Html Manual Window „Main Window Using this printer as a Shared Printer Using the PS-9000 Print Server sold separatelySharing the printer Network hub Brother QL- Series Network cable USB cable Controlling with the ESC/P Commands Available CommandsSerial Cables Brother QL-650TD/1050/1050N Installing the Printer Driver Printing Directly from Other ApplicationsFrom Control Panel, open Printers and Faxes Printers Select each item and click Close the Printers and Faxes Printers window Printing from Other Applications Click File-PrintSelect Brother QL-500/550/650TD/1050/ 1050N Uninstalling the Software Uninstalling the P-touch EditorFor Windows Uninstalling the Printer Driver For Macintosh Click Delete Applications-P-touch Editor 3.2 folder Specifications Product Specifications Operating Environment