Multiple records in one document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 20 Jun 2006 15:29 GMT

I am automating a mail merge and need to include multiple records on
one document. I create the data source document with the following
fields:

ClientID
Account#

Some clientids will have more than one account, some will have only
one. In my merge document, I want to be able to list all of the
accounts for one client on one document instead of printing a new
document for each account. Any ideas on how to do this?

Thanks.

Reply to this Message

Peter Jamieson - 20 Jun 2006 18:38 GMT

Word isn't really geared for this kind of thing - if you are using Access,
for example, you should be able to do what you need using the Access report
designer.

However, to do it in Word, see the following articles:

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

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

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

Peter Jamieson

>I am automating a mail merge and need to include multiple records on
> one document. I create the data source document with the following
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message

CheapTequila - 23 Jun 2006 19:01 GMT

I have a similar problem - I'm using an MS Access database as a data
source. It was suggested that I create a query in MS Access to "join"
accounts that had multiple accounts together so that in one record in
MS Access I wind up with something like:
Account Info 1 xyz^* Account Info 2 xyz^* Account Info 3
When I merge this into my word doc, these will all be on one line - I
need them on separate lines, so then I'll do a search and replace, and
replace "xyz^*" (or whatever strange unique string I use in MS Access)
with a line feed. Haven't tried the MS Access Join part yet, but the
search and replace in Word works.

> Word isn't really geared for this kind of thing - if you are using Access,
> for example, you should be able to do what you need using the Access report
[quoted text clipped - 23 lines]
> >
> > Thanks.

Reply to this Message

Doug Robbins - Word MVP - 23 Jun 2006 20:06 GMT

You should use an Access report.

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 a similar problem - I'm using an MS Access database as a data
> source. It was suggested that I create a query in MS Access to "join"
[quoted text clipped - 36 lines]
>> >
>> > Thanks.

Reply to this Message