Print address label, cards and more.
Get data from MS Excel, MS Access and print on your labels!
Belltech Support Centre


Take Video Tutorials for our products to find out most of your answers. It is a step by step guide to show you how you can do most of work. It's easy, it's fun, just click and watch!


Some Questions and Answers - May help you!


Order-Related Questions Business Card Designer Pro Questions Small Business Publisher Questions Label Maker Questions Database Related - Business Publisher & Label Maker Questions CaptureXT Screen Capture
Please refer to
CaptureXT help pages.

Order-Related Questions

Ttis School Directory Kolkata Site

TTIS School Directory Kolkata is an exhaustive online directory that lists some of the best schools in Kolkata. The directory provides a detailed overview of each school, including their address, contact information, academic programs, extracurricular activities, and other relevant details. The directory aims to provide parents, students, and educators with a one-stop platform to explore and discover the various educational institutions in Kolkata.

Kolkata, the cultural capital of India, is home to some of the most prestigious and renowned educational institutions in the country. With a rich history of producing talented individuals, Kolkata's education sector is highly regarded across the nation. In this context, the TTIS School Directory Kolkata comes into play, serving as a comprehensive guide to the various schools in Kolkata.

In conclusion, the TTIS School Directory Kolkata is an invaluable resource for anyone looking for information on schools in Kolkata. With its comprehensive list of schools, detailed school profiles, and user-friendly interface, the directory is an essential tool for parents, students, and educators alike. Whether you're looking for a school that excels in academics, sports, or extracurricular activities, the TTIS School Directory Kolkata is the perfect place to start your search.

Business Card Designer Pro

TTIS School Directory Kolkata is an exhaustive online directory that lists some of the best schools in Kolkata. The directory provides a detailed overview of each school, including their address, contact information, academic programs, extracurricular activities, and other relevant details. The directory aims to provide parents, students, and educators with a one-stop platform to explore and discover the various educational institutions in Kolkata.

Kolkata, the cultural capital of India, is home to some of the most prestigious and renowned educational institutions in the country. With a rich history of producing talented individuals, Kolkata's education sector is highly regarded across the nation. In this context, the TTIS School Directory Kolkata comes into play, serving as a comprehensive guide to the various schools in Kolkata.

In conclusion, the TTIS School Directory Kolkata is an invaluable resource for anyone looking for information on schools in Kolkata. With its comprehensive list of schools, detailed school profiles, and user-friendly interface, the directory is an essential tool for parents, students, and educators alike. Whether you're looking for a school that excels in academics, sports, or extracurricular activities, the TTIS School Directory Kolkata is the perfect place to start your search.

Small Business Publisher
Q. How do I use my letterhead with Microsoft Word document?
A. 1.Save your designed letterhead as an image file.
2.Open MS Word(*.doc)
3.In Word Doc, go to menu: Format->Background->Printed Watermark
4.Select a the letterhead image that you saved in step 1.
5.Choose scale 100% and uncheck Washout option. Click OK. You are done.

Q. How do I print a list of name badges on the same page?

A.
Senario-1: You want to print multiple badges with different names.
Solution:
1. You must first have the list of names in a text file or Excel sheet or in a database file.
2. Then you need to connect your datafile as shown here - data connection

If you don't know how to create the txt/csv/xls file, check out these samples:
a. data in plain text file - sample-name-address.txt
b. data in Excel sheet - sample-name-address.xls
c data in csv file - sample-name-address.csv

Senario-2: You want to print multiple badges with same names.
Solution:
Just design one badge and then go to File->print menu and select how many you want to print.


Q. I closed the property window. How do I get it back for changing the properties(color, size, tilt angle etc.) of an element?

A. Double click on the element to get properties window. You can change color, size, tilt angle etc. there.

Q. How can I send my design to a printshop for professional printing?

A. Use the 'Save As Image' command from the File menu to save your design as an image file. Then take the image to your printshop for professional printing.

Q. How do I use new font with the application?


Q. How do I use an image file that is in an unsupported format?

A. Convert the file to BMP format or to any supported format and use it.

Label Maker Pro (previously Label Maker With Data Merge)
Q. What types of data files are supported?
A. Microsoft Excel, Microsoft Access, CSV, txt or any any tab delimted files are supported.

Q. How do I connect to my data files?

A. Click on the "Set Database" button on the left side as shown below.
You can also click on menu: File-->Database Settings to set up your data files.
Then go to menu: Insert-->Text From Database to insert a text.


Q. I want to print address labels from my Excel files. Do I need to know SQL?

A.
For most cases SQL knowledge is not required.
Steps to use excel data source:
1. Click on menu: File->Database settings. A Datasource Window appears.
2. Select excel option and browse to your excel file.
3. Now you will see a dropdown with all the excel sheets in the excel file.(an excel file may have one or many sheets)
4. Select the execl sheet you want from the dropdown.
5. Click ok.

At this point you have connected to your excel sheet with your work.
Now go to menu: insert->text from database, and insert an element to your design work. Then go to righthand side's properties area and see a drop down with all the columns in your selected excel sheet. Choose one column and you are done.
Then take a printpreview from file menu.

Q. How do I print only one label at a specified location on my sheet?

A. Suppose you have a sheet of 10x3 (30 TOTAL) labels and you want to print one label in position 8th row and 2nd column.
Then you choose this option in print window:
No. of rows=8
No. of cols=2
Start printing from row=8, col=2.
See illustrated image. The postion marked yellow will only be printed.

Q. How do I convert my date to format like January 5, 2005 or 01/05/2005 etc.?

A. MS Excel return the value as YYYY/MM/DD HH:MM:SS. You need to convert using SQL like this:

SELECT * Format(CStr(MyDate),'mmmm dd, yyyy') as DateNew FROM [Sheet1$]
[This will convert the date to this format: January 5, 2005]

SELECT Format(CStr(MyDate),'mm/dd/yyyy') as DateNew FROM [Sheet1$]

[This will convert the date to this format: 01/05/2005]
You can use many other format strings like Format(CStr(MyDate),'m/d/yy'), Format(CStr(MyDate),'m-d-yy'),Format(CStr(MyDate),'mm-dd-yyyy') etc. Put the SQL statement in the text box as show below:

Q. How do I join 2 fields into one. Like FirstName, LastName into one single line, or Addrs1, addrs2 into one field? ttis school directory kolkata

A. First connect to your datafile as mentioned here. Then follow these steps.

Step 1:

Select the 2 fileds(example FirstName, LastName) you want to join by holding "Ctrl" Key and clicking on them.

Step 2:
Then click on the tool button as shown, or select from menu: Tools->Merge selected DB-Texts Select


Q. How do I add automatic label counter, like 1 of 100, 2 of 100 or 1/100 ?

A. Use [#num#] in text.


Database Related - Business Publisher & Label Maker Questions
Q. How can I pull data from 2 or more sheets from a single Excel file?
A. You can pull data from 2 or more sheets from an excel file. You will need to use SQL statement in data source window. Here is a sample SQL for this sample.xls file:

SELECT [SheetName$].Name, [SheetAddress$].Address FROM [SheetName$] , [SheetAddress$] where [SheetName$].ID=[SheetAddress$].ID


Q. How do I connect to my data files, Access or Excel sheet?
A. Steps 1:
Click on menu: File-->Database Settings to set up your data files.

Steps 2:
Then go to menu: Insert-->Text From Database to insert a text as shown.

TTIS School Directory Kolkata is an exhaustive online

Steps 3:
Then click on the text. You will see "<<TextFromDB>>" .

After that you will see a dropdown in the properties area. In the dropdown you will see all the columns that your Access Table or Excel Sheet has. Select the column(e.g. Name) to show in this text element.

Steps 4:
Repeat step 2 and 3 to select other columns (e.g, Address, City etc.)

Steps 5:
Go to menu File->Print Preview to see a preview as shown. If things look fine, print your labels.

Kolkata, the cultural capital of India, is home

CaptureXT Screen Capture
Please refer to CaptureXT help pages.

home  |  buy  |  products  |  services   |  support  |  privacy policy  | 
Copyright © 2001-2009 Belltech Systems, Inc. All rights reserved