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

Tip: Looking for answers? Try searching our database.

DYNAMICALLY merging MSAccess Data into Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
word_novice - 20 Jul 2006 17:45 GMT
Hi,

I am familiar with merging documents in Word via creating bookmarks and
populating the them from a data source. I am also fairly familiar with
merging relational data into Word.

My current problem is that I am trying to merge some fields in an Access
database table to a Word template document. However, the bookmark only exists
in one paragraph and often there are more than one items in the database
table of the same type.

I will illustrate with an example.  If my main document with the
bookmarks/merge fields is this:
=====================================================
Hi XXX,

Here are the details of your enquiry:

1. XXX  followed by standard block of text                  
           xxxx  followed by standard block of text        
=====================================================
If my document needs more than one paragraphs WITH THE SAME TYPE OF MERGE
FIELDS, how can I automate word to replicate this over the number paragraphs
I want without the need for excessive templates or excessive copy and pastes.

You see, if I have just one paragraph, the merge works just fine. If I have
4, i could merge and replicate the paragraphs by copy and paste but if i have
25, I need a way to merge not only the first field but also subsequent fields
with the same standard block of text.

I have spent 3 months trying to solve this. please help. any suggestion will
be highly valued. i dont even mind doing some programming.

Many thanks.
Doug Robbins - Word MVP - 20 Jul 2006 19:29 GMT
I would use a report in Access.

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

> Hi,
>
[quoted text clipped - 37 lines]
>
> Many thanks.
roccogrand - 12 Sep 2006 22:06 GMT
After working on this problem for an hour or so myself, I came with one work
around.  

Use an Access query to define the extra fields you need and then use them
for your bookmarks.  As long as you have a pretty good idea as to the number
of times that you need to use the same text, this should work with a little
error trapping for null strings.  I am still experimenting with it myself.

HTH

LDN

> Hi,
>
[quoted text clipped - 30 lines]
>
> Many thanks.
 
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.