[Jo4321]

I have created a database to do mailings and envelopes. My boss would also
like a one or two page list showing all the folks the letter was sent to,
along with some other information from the database. I created a word
document to put this in. I use the directory function to run the merge,
however, when I run the merge, the titles of my columns come up on each
record (rather than being one long table with only one heading).

To help visualize, my word doc "directory" is set up like so:

NAME ADDRESS SCHOOL
name address block school

When I do the merge, it comes out like this

NAME ADDRESS SCHOOL
John Doe 123 Anywhere St. Univ. of MD
Anytown, MD 12345

NAME ADDRESS SCHOOL
Jim Beam 456 Anywhere St. Univ. of MD
Anytown, MD 12345

NAME ADDRESS SCHOOL
Jack Daniels 111 Malt Lane Penn State
Anytown, MD 12345

But what I want is this:
NAME ADDRESS SCHOOL
John Doe 123 Anywhere St. Univ. of MD
Anytown, MD 12345
Jim Beam 456 Anywhere St. Univ. of MD
Anytown, MD 12345
Jack Daniels 111 Malt Lane Penn State
Anytown, MD 12345

I tried to remedy this problem by taking the column titles out and making
them a "header" in word, however, now there is a space between the header
and the first record. I can't get figure out how to get rid of the space.
(I could send an example if anyone would like to see what I mean)

Maybe there is a totally different way using reports in access, but I
couldn't figure it out, because my name and address fields are all separate
fields.

TIA,
Jo

[Jo4321]

Well, I see my little visual didn't come out right, and then I realized that
my table is set up that the first field is the entire address block, not name
separated from address

NAME/ADDRESS SCHOOL DATE ATTENDING
address block school date

[Peter Jamieson]

Either
a. do the merge, then add the heading row manually at the end or
b. enable Word's Databaase menu and insert the data using a DATABASE field
(but you will either need the address to be in a single field in your Access
database, or to create an Access query that joins the pieces of address into
a single field, or to modify Word's Database field SQL to do that).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jo4321" wrote in message
...
Well, I see my little visual didn't come out right, and then I realized
that
my table is set up that the first field is the entire address block, not
name
separated from address

NAME/ADDRESS SCHOOL DATE ATTENDING
address block school date

[Jo4321]

Thank you. I can't believe the answer was so obvious! I added the heading
row manually.

Jo


"Peter Jamieson" wrote:

Either
a. do the merge, then add the heading row manually at the end or
b. enable Word's Databaase menu and insert the data using a DATABASE field
(but you will either need the address to be in a single field in your Access
database, or to create an Access query that joins the pieces of address into
a single field, or to modify Word's Database field SQL to do that).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jo4321" wrote in message
...
Well, I see my little visual didn't come out right, and then I realized
that
my table is set up that the first field is the entire address block, not
name
separated from address

NAME/ADDRESS SCHOOL DATE ATTENDING
address block school date