I guess, again, I'm not making myself clear. Instead of using the
"mailmerge" function within Word, I am inserting code into my file by using
the InsertDatabase function to connect to an Oracle database and pull only
the fields I want. I insert these as fields so I can update them at any
point.
I'm linking to an Oracle database by using an .odc file which contains my
connection information. Following the \c command with my connection
information, I have the \s string with my my SQL statement to pull only the
fields of data I need. I am selecting to insert the data as a field so I can
do the update field command. And this works quite well, except for two things
-- one of my text fields is being truncated at 40 characters after it is
imported and it has brackets around it which I cannot remove.
> Hi =?Utf-8?B?a2xhdg==?=,
>
[quoted text clipped - 24 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)
Cindy M -WordMVP- - 30 Apr 2005 14:21 GMT
Hi =?Utf-8?B?a2xhdg==?=,
> two things
> -- one of my text fields is being truncated at 40 characters after it is
> imported and it has brackets around it which I cannot remove.
A text field in the Oracle database, then? What data-type is this field? Is
the text within the brackets in some way related to this field's name, or
its content? Is it in the database record, or in the database at all?
Actually, what you describe still sounds an awful lot like a mail merge
field, and not a database field. The mergefield name will get truncated at
about 40 characters. And the field name will appear in <<brackets>> if
you're not connected to a valid data source, or if you're not displaying
the data preview. You might press Alt+F9 and check the field codes...
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 :-)