Data Source Files For A Mail Merge in Word 2000! Part 1 of 2
For a mail merge, you need a data source file that contains a
record on each item. For instance, a record might be one person's
name and mailing address, or a part number with its dimensions and
price.
This data file can be in one of many different formats. It may
already be in a Word table, an Excel file, an Access database
table or query, a comma-separated file (CSV file), or other file.
The data may already exist in your Outlook address book or
Contacts folder.
You do not need to use all of the information in your data file to
perform the mail merge. You may have an employee list that
contains addresses, but also contains social security numbers and
salaries. Your data file can be left intact and information that
isn't used can be ignored. You can continue to use your data
source files for other purposes; using it to perform a mail merge
in no way affects your existing file.
The data source file must be formatted so that the column headings
(also called labels or field names) are the first line or row in
the file, and the first record is the second line or row in the
file.
Once you are certain that your data source file meets this
criteria, you can continue with the mail merge.
Quickly Setting a Print Area in Excel 2000!
Your users probably waste a lot of time and paper sending entire
worksheets to the printer when all they need is a printout of a
few columns or rows. Teach them this quick trick to set specific
print areas within the Print Preview mode.
1. Select View | Page Break Preview.
2. Select the cells you want to print.
3. Right-click the selection and choose Set Print Area from the
shortcut menu.
Click Print.
Loop Your PowerPoint 2000 Slide Shows!
Suppose you want to place a monitor that continually shows a
PowerPoint slide show in your store window. The best way to do
this is to choose the Kiosk mode. Run PowerPoint and open your
slide show. Now, choose Slide Show>>Set Up Show. When the dialog
box opens, select the "Browsed at a kiosk (full screen)" radio
button and click OK to close the dialog box and save your
selection.
You'll need to set up some timings, so choose Slide Show>>Slide
Transition. Select the check box labeled "Automatically after" and
set the time you want between slides. Click Apply to All to set
all the slide timings to the same value and close the dialog box.
You'll need to press Esc to stop the show.
====================
Visit My Customer Support Pages!
http://internetfixes1.brinkster.net/customer_support/
Database Download Center!
http://internetfixes1.brinkster.net/customer_support/Down_Load_Center1/index.htm
DOS Command Index!
http://internetfixes1.brinkster.net/customer_support/batch_files/batch_11.htm
Learn How To Backup The Registry!
http://internetfixes1.brinkster.net/customer_support/registry_tips/registry.htm
Backup your Registry in Windows XP!
http://internetfixes1.brinkster.net/customer_support/registry_tips/registryXP.htm
Visit our Quick Over View of my Remote Connection Service!
http://www.internetfixes.com/remote_setup/quick_index.htm
Remote Connection Help Service Hours!
http://www.internetfixes.com/remote_setup/hours.htm#Remember_all
Have Questions on Microsoft Windows & Office Products? Try my New
Forms!
http://www.internetfixes.com/question.htm
Help Desk Techs!
http://www.internetfixes.com/help_desk_techs.htm