If the database is an Access database, the solution is not too
difficult. A working knowledge of MS Query is useful, but if you have
none, now is the time to learn! If the data is not an access
database, it gets more tricky, but it is still possible. I'm going to
operate under the assumption you're using an Acess Database for now.
(I'm working with Word 2000, so your dialogs/etc may be slightly
different.)
Step 1: Prepare the seed document
In Word, start with a blank document. Select Tools->Mail Merge.
Under section (1), click "Create" and choose "Form Letter." Use the
current document. Now choose the "Edit" button which appeared, and
select your document. Now create your letter as usual. Use regular
names, numbers, etc. or descriptions such as "FIRST_NAME" "LAST_NAME",
so forth. When this is prepared, you can move to step 2.
Step 2: Gather your mail merge data
Select Tools->Mail Merge. Under part (2), choose Get Data and say
"Open Data Source." Browse to where your Access Database is and open
it. (You may need to change the drop-down file type box to "Access
Databases" to see your database in the file browser.) A new window
will pop up, containing the names of all tables in your database.
Select the table that has the data you need, and click "OK". Word
will inform you that you have no merge fields in your document. Click
the "Edit Main Document" button, and you'll be sent back to your form
letter.
Step 3: Insert the merge fields
Merge Fields are the data from each Database record that will replace
"FIRST_NAME", "LAST_NAME", etc. in your form letter. Look for the
Mail Merge toolbar. (If you can't find it, choose
View->Toolbars->Mail Merge to bring it up.) Click the "Insert Merge
Field" button, and it will pop down with all the entries in the table
you selected from step 2. You can now insert these fields at will
into your document in place of the "FIRST_NAME" fields you had before.
You can insert the same data multiple times -- if you want the first
name to appear at the top and bottom, insert the same field in both
places. (When mail merge fields are inserted they look like
"<<FirstName>>"). Do this for every place where you need to in your
form letter.
Step 4: MERGE!
Now, on the merge toolbar, click "Merge...". Choose to merge to a new
document. (At this point, you can even which records you want to
merge, and a couple more options.) Then click "Merge." You will now
have a brand-new single document containing all of your merged
letters.
Now, this procedure will work for more than just MS Access databases.
If you can't open your database file directly, the best solution may
be to EXPORT it into a text file. If this is what you have to do, I
can write a detailed description of how to do it.
Hope this helps! |