Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jo4321 Jo4321 is offline
external usenet poster
 
Posts: 5
Default Data from access database into a word table

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








 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing data from a database (Excel or Access) into Word documen kiwi Microsoft Word Help 3 May 22nd 06 08:59 PM
How do I access a FileMaker Pro database to generate my data sourc newbie Mailmerge 1 June 28th 05 09:10 AM
Extract data from word doc to access database CAD Fiend Microsoft Word Help 1 June 22nd 05 05:24 PM
Mailmerge data source in an Access database will not open Colin C Mailmerge 3 December 31st 04 12:01 AM
Using as secured Access database as the data source for a mail mer Carmine Mailmerge 1 December 10th 04 05:25 PM


All times are GMT +1. The time now is 07:51 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"