Hello All,
I have a word template that has been used by my company for the last 5 years. The template would be useful now if I can figure out a way to export a user defined query in Access to this word file. However, when I use the mail merge function I can define the fields I would like imported but it selects all records unless I scroll and click repeatedly. I wish to eliminate the need to do that. If I use the "Publish it" function in Access I can export the selected records but not to a predefined file.
I have tried to import the existing template to Access as a Report but I cannot expand the report and replicate a table when I have multiple listings in a 1-many relationship.
Is it possible to "publish" my selected information in a Word Template? Can I create a Macro in Word or Access that defines the placement of each field in the exported File? or Can I create an expanding report that duplicates a table in a report when multiple entries are found in the query?
If any of these are possible, step-by-step instructions would be very helpful. If not, can anyone suggest an alternative solution to creating a predefined report.
Thanks
I have a word template that has been used by my company for the last 5 years. The template would be useful now if I can figure out a way to export a user defined query in Access to this word file. However, when I use the mail merge function I can define the fields I would like imported but it selects all records unless I scroll and click repeatedly. I wish to eliminate the need to do that. If I use the "Publish it" function in Access I can export the selected records but not to a predefined file.
I have tried to import the existing template to Access as a Report but I cannot expand the report and replicate a table when I have multiple listings in a 1-many relationship.
Is it possible to "publish" my selected information in a Word Template? Can I create a Macro in Word or Access that defines the placement of each field in the exported File? or Can I create an expanding report that duplicates a table in a report when multiple entries are found in the query?
If any of these are possible, step-by-step instructions would be very helpful. If not, can anyone suggest an alternative solution to creating a predefined report.
Thanks
