Merging Access Data into Word Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Risdal - 30 Aug 2005 21:28 GMT

Our system uses the MS Office 2003 Professional. I am attempting to merge an
Access query with a Word document. The query uses various tables to compile
the information needed for the document. As a quick overview of how the
information is used, the form starts with the name, address, etc. of the
client. It then moves into a table that lists a list of names authorized for
the client. I use the "Next" and the "Next if..." fields to create the list
of names. At the end of the form I need to have some general client
information.

However, if the client only has 2 names to list and I have created space for
four using "Next", etc., the last record is "blank" and I am unable to
generate the general client information at the end of the form.

How can I tell the form to go back to the first record so I can use the
general client information?

Any suggestions are appreciated. Thank you.

Reply to this Message

Doug Robbins - 31 Aug 2005 05:22 GMT

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Or take a look at the following Knowledge Base Article

How to Work Around Duplicate Names in Mail Merge Data

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

However, as the data is in Access, I would use a report in Access to do what
you want with the company details as a group and the holders of the catalog
in the details.

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

> Our system uses the MS Office 2003 Professional. I am attempting to merge
> an
[quoted text clipped - 18 lines]
>
> Any suggestions are appreciated. Thank you.

Reply to this Message

Risdal - 31 Aug 2005 15:59 GMT

Thanks for your help. I checked the information you provided and found some
things that were definately helpful, but not for this specific situation.

Unfortunately I am unable to use Access to create this report as not
everyone who needs to use this form has full access to the database -
security set up by our IS department.

Thanks again!

> Word does not really have the ability to perform a "multiple items per
> condition (=key field)" mailmerge.
[quoted text clipped - 36 lines]
> >
> > Any suggestions are appreciated. Thank you.

Reply to this Message

Rate this thread: