Label Factory: Importing Data from Outlook
Label Factory Deluxe 3.0 is a label creator that comes installed with pre-formatted templates and labels. With this program, users simply need to type or export their contacts’ information to the program and select the label format that they would like to use. Then, they just need to select their printer and/or printer settings and print out the labels, making this a fast way to send out corporate or personal mail. This program also allows users to import their contacts from Microsoft Outlook, eliminating the need to manually type in those contacts.
Step 1: Exporting Outlook Contacts to Excel
Label Factory Deluxe can only read files that are in the dBASE III format. So, the first thing you need to do is to export their Outlook contacts to Excel, where the user can then save the file in the correct format.
To export contacts from Outlook to Excel, go into Outlook’s File Menu, and select the Import and Export option. Select Export to a file, and hit Next. Then, select Microsoft Excel, and then hit Next again. Now, select the Contacts folder, and click Next again. Select the location where the file should be saved and give it a name. Then, hit OK, and then hit Next. Once done, click Finish.
Step 2: Creating a DBASE III File
Now, it is time to convert the Excel file into the dBASE III format. So, go ahead, and open the exported file. Then, go into the Edit menu. Next, while holding down the Control key, press the letter A.
Open up the Format menu, and click on Format Cells. Next, make some adjustments in the Format Cells tab. The following changes should be made:
- Number Tab - change the Category to General
- Alignment tab - change Horizontal to General and Vertical to Bottom
- Font tab – select the Normal font option
- Patterns tab – click on No Color
- Border tab – select None
- Protection Tab – deselect all checkboxes
Once done, click OK, and then go into the File menu. Go to the Save As menu, and pick DBF3 (dBASE III) (*.dbf). Next, create a name for the file, and hit save. The file will now be saved as a dBASE III file, which can then be opened in Label Factory Deluxe.
Step 3: Opening the File in Label Factory
Now, open up Label Factory, and open up the Database menu. Hit open, and then Open a dBASE III Database. A pop-up menu will appear with the folders on the desktop. Scroll through the files, and select the dBASE III file that was just created. Open it. This will import all the contacts from Outlook into Label Factory Deluxe.
Step 4: Troubleshooting
If the created file cannot be opened in Label Factory, it could be due to the fact that the user was creating the file in a later version (after 2000) of Excel. Sometimes Label Factory Deluxe has issues reading the dBASE III files created with these later models. If that is the case, you may just have to manually type up your contacts.