Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Michael Michael is offline
external usenet poster
 
Posts: 154
Default Insert database information in non-table

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   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Insert database information in non-table

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the table format when using Insert Database function Cindy B Mailmerge 1 March 11th 07 08:13 PM
Using Insert Database Janie Tables 1 October 17th 06 11:52 AM
Inserting database information echobob Microsoft Word Help 1 June 16th 06 09:42 PM
Where does MS Word 2003 store the database login information [email protected] Mailmerge 0 November 7th 05 04:21 PM
enter database information into template Suznrae Microsoft Word Help 1 January 27th 05 08:27 PM


All times are GMT +1. The time now is 07:47 AM.

Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"