Merge data in body of a letter

  • Thread starter Thread starter jeff rowland
  • Start date Start date
J

jeff rowland

Need help trying to figure out how to create a letter that
will merge data from a database into the body of a letter.

Ex. Have a access database with a table that has 3 fields;
class name,start date, end date. What I would like to do
is produce a letter that will say something like.

The following classes will be available during the next
4 months:

Class Start Date End Date
xxxxxxx xxxxxx xxxxxxx

The program would perform a merge that will print a letter
with the above info in the body of the letter for each
record in the database

IE. If the database has 3 records:
CITP-401 12/01/03 12/31/03
BITP-401 01/01/04 01/31/04
FITP-401 02/25/04 02/28/04

The letter would print as follows:

Dear XXXXX,
The following classes will be available during the
next 4 months:

CLASS START END
CITP-401 12/01/03 12/31/03
BITP-401 01/01/04 01/31/04
FITP-401 02/25/04 02/28/04

Not sure how to set up a merge to print out multiple lines
in the body of the letter using data from the database.

Thanks
 
Using the Catalog Option of the Mail Merge process (Word 2000) I was able to
achieve the "listing" of the data within a single record. If you intend
this to also be a "form letter" addressed to multiple recipients -- this
won't do that.

Create your letter -- then in the Mail Merge process -- select Catalog --
then insert (in your desired layout) the following

Class Start Date End Date
(assuming those are the field names)
Next Record Class Next Record Start Date....

When you run the mail merge in the active document -- you will have to drop
menus to choose from Insert Merge Field and Insert Word Field --- pull your
field names from the Merge Field drop and the "next record" from the Word
Field drop.

That should create a single letter comprised of the list from your database.

Kate in MN
 
Back
Top