Creating Address Labels with using EXCEL or ACCESS data

1. Choose Database > Open... in menu bar

2. When Open Data window popup, select a file type from Files of Type combobox and click open button.

3. Choose Yes to convert a file type to mdb format (This is the file type supported in Formtec Design Pro 6) in dialog box and input a new file name to save in Field Name textbox.

4. When a new file name to save data is entered, Select Converted File window popup. You can just click Convert button or you can make adjustments such as field size by selecting the list from Table Definition. Selected list is shown in the field information and field size can be adjusted. After field adjustment, click Convert button.

5. After clicking Convert button, the following Information dialog box for successful database conversion popup.

6. After selecting checkboxes to labal, if clicking OK button, Data Input/Browse windows popup. After confirmation, click close icon

 

7. After finishing data input, click close icon, then Select Print Range window popup. Choose print range of the label and press OK button.

 

8. After selecting print range, Select Sheet window popup. Select label code and press OK button.

 img75.gif

9. After selecting a sheet, Field Layout window popup.

The list of field you made in Data Input/Browse windows appears. Click > button to add fields to Field Layout, and also these fields can be moved by mouse. Click < button to remove from the Field Layout.

 

10. After finished field layout, if click OK button, First data of fields appears in the labelin design windows. You can change edit the font style or etc. If you want to adjust the size of the object, after selecting the address and Field Property window popup, deselect Auto Align checkbox and click OK button. Adjust the object size to see all two lines with left button pressed.

 11. If you add same honorific titles or cliparts to entire labels, after clicking text input(img1131.gif) button, Input the text you desire, or after cliking clipart button, selecting the clipart you desire. You can see honorific titles or cliparts you input is in all the labels in Preview window.