Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data from access database into a word table
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data from access database into a word table
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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data from access database into a word table
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from a database (Excel or Access) into Word documen | Microsoft Word Help | |||
How do I access a FileMaker Pro database to generate my data sourc | Mailmerge | |||
Extract data from word doc to access database | Microsoft Word Help | |||
Mailmerge data source in an Access database will not open | Mailmerge | |||
Using as secured Access database as the data source for a mail mer | Mailmerge |