This document includes several screenshots showing the
functions of the Address List Database as it is seen during use.
Additional instructions can be supplied.
This screenshot shows the Address List Database as formatted for details of individuals:
In order, from left to right, the column headings are:
First Name, Surname,
Address1, Address2, Address3, Address4, Address5, Address6, Postcode, Telephone Number,
Category 1, Category 2 and Comments
Categories 1 & 2 feature drop-down menus for you to qualify categories of contacts. This enables you to select just part of the overall database eg for printing labels. The menus are set by default as Category 1 : Prospect, Active Customer and Ex-Customer
Category 2 : UK and Abroad
We can re-set these for you, or they are easy to change and add to yourself.
The Comments column enables you to add further notes.
The database defaults to organising records in alphabetical order of Surname. However, this also can be varied by selecting the top box of any column then clicking either the A>Z button or the Z>A button on the tool bar at the top.
Furthermore, other sets can be selected using the Filter By Form function. Once this is clicked, a new blank record is displayed. Enter any information in any box, then click Apply Filter, and only records containing identical information will be selected. In this way, records can be sorted by Town, by Postal Code, by STD code, by Surname, or any other parameter that you desire. This is particularly useful when used in combination with the drop-down menus options in Categories 1 & 2, enabling you to divide mailshots into Customers and Prospects, or into UK and Abroad.
When the Address List Database is first opened, an Options Menu is displayed:
The buttons to the left enable different functions to be selected.
The first button shows Address Records singly:
In this option, there is a full range of buttons to scan through records; to delete, modify or add records; or to print in a variety of different ways.
The second button on the Options Menu allows you to view multiple records:
In this option, there is also a full range of buttons to scan through records; to delete, modify or add records; or to print in a variety of different ways.
The third button on the Options
Menu enables you to select a category of records to be printed.
This layout will present records for printing onto A4 sheets of address labels.
We use Avery LA21-100 sheets, although the Page Setup option under File does allow this to be varied as with any other document.
The fourth button on the Options
Menu enables you to select a category of records to be printed
( but this time it will be for a landscape printout onto A4).
The fifth and sixth buttons on the Options Menu enables you to modify or add to the combinations on the drop-down menus of Categories 1 & 2:
The seventh button on the Options Menu simply closes the database.
The full screen of the option ‘Multiple Addresses’ contains a useful box, bottom left.
This is labeled in blue Full Address For SmartLabel Capture.
Whenever the cursor is clicked onto a cell of a completed address record, this box will display the full address – and clicking on the blue title will highlight it all.
A simple right click of the mouse brings up the menu to ‘Copy’ all of this address.
In this way, the complete address for a contact can be prepared for pasting onto an address label, or for pasting into a document.
For printing address labels, we have always used a Seiko Smart Label Printer – hence the title chosen for that box.
There may be several small, inexpensive printers suitable for this task, but the Seiko range is ideal for the small business user who wishes to call up customer records throughout the working day, then quickly copy ‘n paste the address onto a label for a letter or parcel for dispatch. The printer will utilise a variety of labels, but the 28x89mm Address Labels are ideal for routine use on envelopes and packages.
The Seiko Smart Label Printer uses a variety of different label sizes and different substrates, but will print out single or multiple labels in seconds. It is simplicity itself to install, and has a WYSIWYG interface allowing you to build up sets of standard templates for routine use.
Used in combination with the Smart Capture facility it is quick and easy to transfer data from the Address List Database onto a printed Seiko label:
On the Smart Label user interface, just click File, then Paste.
The address captured from the database is instantly copied onto a label template:
Then click file and Print, and you have a printed label!
For more information, and/or to purchase from Amazon, click this link: Seiko Smart Label Printer.