Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging Access Data into Word Document
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. |
#2
|
|||
|
|||
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/cindy...r/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...b;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" wrote in message ... 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. |
#3
|
|||
|
|||
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! "Doug Robbins" wrote: 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/cindy...r/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...b;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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 | Microsoft Word Help | |||
apply a template to existing documents | Page Layout | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
creating forms | Microsoft Word Help |