Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2007

Tip: Looking for answers? Try searching our database.

Creating a form for Word Table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben - 10 Apr 2007 19:45 GMT
I've linked a word document to an existing Table I have setup
connected to an Oracle Database vis MS Query.

The result worked great, and data was retrieved into an MS Word
table.  The
only problem, it captured and placed as a row of fields at the top of
my word document, with all data below.

What I need to be able to do is format this into more of a Form type
of MS Word output.  How do I create the form and then link the fields
from the table so it is laid out as I need it?

Thanks
Peter Jamieson - 10 Apr 2007 21:36 GMT
It sounds as if you have used Insert|Database to insert your table.

Another way to use data from your table is to create a MailMerge.

If you are using Word 2002 or 2003 I would use Tools|Customize to enable the
MailMerge toolbar, then start with the button at the left hand end and
create a Directory merge. Then use the next button to connect to your data
source. Then you can use button 6 to insert "MERGE fields" into your
document. Each is a placeholder for data from a column in your Oracle table.

There are several ways you can achieve a "catalog" style layout, e.g.
a. use tabs to layout out a "Title" or tag" and a field on each line, e.g.
suppose your data source has fields called field1,field2 etc. then you can
use

field1: <<field1>>
field2: <<field2>>

etc., where<<field1>>, <<field2>> are the mergefields you inserted.

b. If you want to suppress lines where the fields are blank, there are a
couple
of possibilities. For text fields, you can usually use a switch in each
field, e.g. use Alt-F9 to show the field code

{ MERGEFIELD field1 }

then change it to

{ MERGEFIELD field1 \b "field1:<tab>" }

where <tab> is a tab character.

Or you can use nested IF fields, but let's not go there now.

c. If you don't need to suppress blank lines and there are text fields that
will wrap, or you want to apply visible borders to each field, you can put
the tags and fields inside a table. But Word cannot suppress rows in a table
just because the content is blank.

Peter Jamieson

> I've linked a word document to an existing Table I have setup
> connected to an Oracle Database vis MS Query.
[quoted text clipped - 9 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.