Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2007

Tip: Looking for answers? Try searching our database.

Data from access database into a word table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jo4321 - 17 Oct 2007 14:10 GMT
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 - 17 Oct 2007 14:35 GMT
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 - 17 Oct 2007 16:35 GMT
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).

Signature

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

> Well, I see my little visual didn't come out right, and then I realized
> that
[quoted text clipped - 4 lines]
> NAME/ADDRESS        SCHOOL    DATE ATTENDING
> <address block>      <school>    <date>
Jo4321 - 17 Oct 2007 21:37 GMT
Thank you.   I can't believe the answer was so obvious!  I added the heading
row manually.

Jo

> Either
>  a. do the merge, then add the heading row manually at the end or
[quoted text clipped - 11 lines]
> > NAME/ADDRESS        SCHOOL    DATE ATTENDING
> > <address block>      <school>    <date>
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.