Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Is there a way to insert database information so that it is not put into a
table. I would also like to be able to specify the formatting and other things similar to merge fields on a per field basis. So far I know about the "DATABASE" field which does some of what I want: it displays all of the data that i want, but just in a table format. I also know about the "MERGEFIELD" fields, which do pretty much everything that I want except they are only linked to one data source (which i want to be able to pull data from different sources into one document) and would also like to display all of the fields in the current document. (where as I understand it merge fields are usually used to create other documents). Now just in case my description above was not clear, I will try to explain what I'm doing. As a simple example lets say I just want to create a title sheet with information pulled from a data base (actually I'm creating a template but that probably doesn't matter). So I want this template to get the title and author from one query to the database. But I also want to include all comments for that title that are kept in a different table. So without formatting it would look something like this: ------------------------ Title By: Author Comment1 Comment2 Comment3 ------------------------ the trick here is that different titles will have different number of comments Hopefully this explains my problem enough and hopefully someone can give me some guidance on this so I look forward to any responses. Thank You. |
#2
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Hi ?B?TWljaGFlbA==?=,
Is there a way to insert database information so that it is not put into a table. I would also like to be able to specify the formatting and other things similar to merge fields on a per field basis. So far I know about the "DATABASE" field which does some of what I want: it displays all of the data that i want, but just in a table format. I also know about the "MERGEFIELD" fields, which do pretty much everything that I want except they are only linked to one data source (which i want to be able to pull data from different sources into one document) and would also like to display all of the fields in the current document. (where as I understand it merge fields are usually used to create other documents). The only way this can be done is by using macros. In the Mail Merge FAQ on my website, special merges section, there's a download file WdAcc97.zip that basically outlines how this can be set up. Don't know if that will help you at all, since you don't give any particulars about the "data sources"... Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) 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 | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the table format when using Insert Database function | Mailmerge | |||
Using Insert Database | Tables | |||
Inserting database information | Microsoft Word Help | |||
Where does MS Word 2003 store the database login information | Mailmerge | |||
enter database information into template | Microsoft Word Help |