Creating and Merging a Database in
Design Pro (Windows)
Merging a Database via ODBC in
Design Pro (Windows)
How to Tag and Untag records in
Design Pro (Windows)
Creating and merging a Database
Open Microsoft Excel and ensure you have a blank sheet open
Firstly we need to add field
headers for the database. Each line of data needs to be added into a different column. Please ensure that there are no spaces in the field headings e.g. address 1 should be address1.
Enter the details as per the sheet shown
Once you have completed your database, you will now need to save this firstly as an excel file then you will need to resave this as a DBaseIII file. (Note if you are using Microsoft Excel 2007 upwards you will need to save the file as an 97-2003 *.xls file and skip to next 2 steps as the Dbase option is not available).
There are 2 ways in which to create a database that you can merge from using the DesignPro software:
1. Using Microsoft Excel
2. Creating a Design pro Database.
You may get a message appear on the screen Click on OK.
If you then get the following screen you will need to click Yes. The database is now ready to use in DesignPro
Open the DesignPro Software and ensure that you have a blank label on the screen Please also ensure that you are on the MASTER tab.
Click on the Database tab on the toolbar and then select CREATE NEW
The Create New Database screen will come up on the screen Click on the first option
You will need to give this database a name. In this case I have called it Test.
Now click Save.
Now Click the second option. This options allows us to create the Field headings.
The Field parameters box will be shown.
Type in the First Field heading then click Add.
You will need to add each field until you have all the field headings entered, then click Close.
The Field headings will now be shown on the box behind.
Once you have completed this click on OK.
This will bring up the screen that you can now start to type your addresses into.
Type the address information according to the field headings as shown then click NEW RECORD
Type the next address and then click NEW RECORD. Follow this process until you have completed your database then click Close.
You will now get the following screen come up. Click Insert Fields
You will now get the following screen come up showing the field names. You now need to insert each one as required onto the label.
Once you have added the details click close.
Your project is now ready to be printed.
Merging a Database via ODBC
Open the DesignPro Software. Select the code of your labels by clicking START, NEW, PROJECT FROM SCRATCH. Type the code of your labels into the Find Item Number option.
You should now have one label showing on the screen.
Click on the Link Database Option.
Click the Machine Data Source tab. Then click New.
Select the System Data Source option Then click Next
Scroll down to the
Microsoft Excel Driver (*.xls) option Then click Next
Click on Finish.
You now need to give this a name Type this into the Data Source Name Box
Now click on the Select Workbook option
Select the Database that you want to use and then click OK.
In this screen you should now have your database name and database that you want to use. Now click OK
You should now see the file listed Click on this file then click OK
Select the Sheet1$ option and click
OK.
Click on the Insert Fields Option
You will now get a box appear with All the field names.
Click on insert and the headings will appear on the label.
You can insert the information as you Want the labels to appear.
Now click the close option on the Insert field box.
Now click File Print.
Select the Print Preview Option and you will now see all your addresses on the label sheet.
How to Tag & Untag records on a database
What is Tagging and Untagging Records?Tagging is where you would select the addresses from your database that you would like to merge onto your labels.
Once you have opened your
database you will need to click on Modify Fields option.
In the Modify Fields option click on the Tag Field option as highlighted and then click OK
If you get a warning box come up click YES
You can now go through your
database by clicking the arrows and click the Tag option on the
addresses that you want to print. Once you have finished click Close.
Now Click on Insert Fields.
Click on the fields that have come up and enter these onto the Label.
In the Print Screen click on Database
Deselect the Print All Records option
And then select the
PRINT TAGGED RECORDS ONLY SUPPRESS SPACES
SUPPRESS BLANK LINES
Options Click OK
Now Click Print Preview
You should now have the addresses that you have selected to print.
