Create a single mailing label in Word 2000!
Microsoft's Mail Merge Wizard is great for mass mailings, but if
you need to create only a handful of labels, using Word's
Envelopes And Labels dialog box is much more efficient.
For example, suppose you need to send the same letter to two of
your customers. Type the letter to the first customer, and then
select the customer's address in the letter. Next, follow these
steps to create a mailing label:
1. In Word 2000, select Tools | Envelopes And Labels. In Word XP,
select Tools | Letters And Mailings | Envelopes And Labels.
2. Select the Labels tab in the Envelopes And Labels dialog box.
The customer's address that you selected will appear in the
Address box.
3. To make formatting changes to the address, select and
right-click it to bring up a shortcut menu, and make any needed
changes.
4. To change or specify the address labels you wish to use, click
the Options button in the Labels dialog box, and click OK to
confirm.
5. Click Single Label, which will display the default: row 1,
column 1.
6. Hand-feed one sheet of labels into the printer and click Print.
The printer will print the address on the first label on the
sheet.
To print the mailing label for the second customer, replace the
first customer's address with the second customer's address in the
letter. Select the address and follow the steps above. However, in
Step 5, enter 2 for the column number. The address will print on
the next available label.
Sorting Excel 2000 Data!
When you have columns of related data that you want in
alphabetical order, you have to make sure that you keep the
columns together. For example, you have this list that you want to
sort, keeping the fruits (column A) and their prices (column C)
together:
Column A Column C
Pears $1.29
Oranges $1.19
Kiwis $1.10
Bananas $1.49
Apples $0.99
In this case, you would select A1 through C5 and then choose
Data|Sort. When the Sort dialog box opens, make sure Column A and
'Ascending' are selected and click OK.
If you fail to select Column C along with Column A, the prices
will no longer represent the correct fruit.
Delete default shortcuts in Access 2000!
Access 2000 provides shortcuts that let you create new objects
just by double-clicking. For example, when you click Tables in the
Objects list, by default you'll see three shortcuts in the
database window: one for creating a table in Design view, one for
creating a table with the wizard, and one that lets you create a
table by entering data.
When you select Queries, Forms, or Reports, you'll see only two
shortcuts: one for working in Design view and one for launching a
wizard. Click Pages, and you'll see the Design view and wizard
shortcuts, plus a shortcut that launches the Locate Web Page
dialog box.
By the time you finish most of your initial design work, your
database window may start to get cluttered. You can eliminate some
clutter and make it easier to locate the objects you use on a
regular basis by getting rid of the default shortcuts. To do so,
go to Tools | Options | View. In the Show section, deselect the
New Object Shortcuts check box and click OK. When you do, Access
stops displaying those shortcuts for all databases.
|
|