Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mailmerging multiple tables from access in one word-document: how?
I have been looking at a problem the entire week in access, I have still not
been able to find a solution. Hope that you could maybe tell where to look Concerns the link between Access and Word. I can not transfer a report to word without losing out on the lay-out (RTF format). I understand that there is no way out ok, mail merge I thought. But here I have the problem that I need to merge multiple tables and that I can just include one in the mailmerge within word. A query would seem likely but there I have a problem. I have one master table containing personal information on staff and 8 subtables around the master table with specifying language, workexp, education for each person. The number of entries in the subtables varies per person. In case I use a query to combine all these tables I get # x # x # x # x# (9 times) number of records an extreme number of records for each person. An example: person A knows 8 languages has 3 educational references 10 publications took 8 courses in his career This would already result in 1 X 8 X 10 X 8 = 640 records Do I miss a certain function with queries or how can I work this out? I can not imagine that it is not possible Thanks and wishing you a good day Stefan van den Hark The Netherlands |
#2
|
|||
|
|||
There is really no way to do that sort of thing with mailmerge. With only
occasional exceptions, I have found publishing an Access Report to Word as an RTF works OK. The exceptions have been on very complex reports where I was really jamming information into the available space and slight differences between the fonts as displayed by Access and Word did throw things off. A bit of judicisious re-formatting in Access usually overcame that problem. Most of the time however, I stick completely with Access, or if I have to send the report electronically, use Snapshot and point the recipient to the website from which they can download the Snapshot Viewer. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "svdh" wrote in message ... I have been looking at a problem the entire week in access, I have still not been able to find a solution. Hope that you could maybe tell where to look Concerns the link between Access and Word. I can not transfer a report to word without losing out on the lay-out (RTF format). I understand that there is no way out ok, mail merge I thought. But here I have the problem that I need to merge multiple tables and that I can just include one in the mailmerge within word. A query would seem likely but there I have a problem. I have one master table containing personal information on staff and 8 subtables around the master table with specifying language, workexp, education for each person. The number of entries in the subtables varies per person. In case I use a query to combine all these tables I get # x # x # x # x# (9 times) number of records an extreme number of records for each person. An example: person A knows 8 languages has 3 educational references 10 publications took 8 courses in his career This would already result in 1 X 8 X 10 X 8 = 640 records Do I miss a certain function with queries or how can I work this out? I can not imagine that it is not possible Thanks and wishing you a good day Stefan van den Hark The Netherlands |
#3
|
|||
|
|||
Hi Stefan,
Whether you could possibly use mail merge would depend on how the information n the sub-tables should appear in the report. If it could basically be presented as a table, then you could link DATABASE fields into the mainmerge document. For anything "fancier" with Word you'd have to use automation (program VBA) to generate the document. I have been looking at a problem the entire week in access, I have still not been able to find a solution. Hope that you could maybe tell where to look Concerns the link between Access and Word. I can not transfer a report to word without losing out on the lay-out (RTF format). I understand that there is no way out ok, mail merge I thought. But here I have the problem that I need to merge multiple tables and that I can just include one in the mailmerge within word. A query would seem likely but there I have a problem. I have one master table containing personal information on staff and 8 subtables around the master table with specifying language, workexp, education for each person. The number of entries in the subtables varies per person. In case I use a query to combine all these tables I get # x # x # x # x# (9 times) number of records an extreme number of records for each person. An example: person A knows 8 languages has 3 educational references 10 publications took 8 courses in his career This would already result in 1 X 8 X 10 X 8 = 640 records Do I miss a certain function with queries or how can I work this out? I can not imagine that it is not possible Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help | |||
macro in word | Microsoft Word Help |