Merging Access Data into Word Document

[Risdal]

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.

 

[Doug Robbins]

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.




--
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

 

[Risdal]

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!