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 / August 2006

Tip: Looking for answers? Try searching our database.

Mail Merging an Access Database to a Table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marilyn - 17 Aug 2006 18:19 GMT
I have an Access Database that I'm using as my data source in order to merge
the data to a table in Word 2003.  When I complete the merge I get a brand
new table for each record that I would like to  have merge.

Is there a way to tell word to merge the next record to the row below?  I
dont want to end up with 50 different tables for each record.

Please HELP!!!
Doug Robbins - Word MVP - 17 Aug 2006 21:05 GMT
I assume that you are using a Directory type mail merge main document for
this.  At least that is what you should be using and in that document, you
should have a one row table in the cells of which you insert the merge
fields and the must be nothing else in the document other than the empty
paragraph mark that will follow the table.  If that is how you have the main
document set up, when you execute the merge to a new document, that document
will contain a table with a row of data for each record in the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an Access Database that I'm using as my data source in order to
>merge
[quoted text clipped - 5 lines]
>
> Please HELP!!!
Marilyn - 17 Aug 2006 21:30 GMT
Doug,

My word document is 68 pages long and I have merge fields throughout the
document including the table that I would like to use to populate the merge
fields to.  

By your answer I'm assuming I will not be able to use the "Directory"
feature in the table within the document.  Is there another way I can have
the merge fields populate within each row of the table?

Thanks,

> I assume that you are using a Directory type mail merge main document for
> this.  At least that is what you should be using and in that document, you
[quoted text clipped - 13 lines]
> >
> > Please HELP!!!
Doug Robbins - Word MVP - 18 Aug 2006 04:46 GMT
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug,
>
[quoted text clipped - 32 lines]
>> >
>> > Please HELP!!!
 
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.