View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
k0_zaw
 
Posts: n/a
Default Error in word mailmerge, it source is Ms Access's richtext fil

Thank you Peter,

So, there is no way ms word know rtf data from Access's OLE field in
mailmerge process. If so, I shouldn't use RTF data in Access field, if i
intend to use then in mailmerge. Regret for my rtf formatting time!!

Wait a minute!
What if I creat another filed (let say, Filed2 with memo type).
And duplicate the "text only data" from RTF field to Field2, and use that
Field2 in word merging instead of RTF filed. Is my idea correct way? if so,
please advice me how i code.

Thank in advance,
Zaw


"Peter Jamieson" wrote:

My point is "want to insert data with text formatting in Access, and use
that data in word mailmerging."


Formatting stored in fields in a data source either do not reach Word or
(where they contain HTML format tags or RTF codes) are not interpreted in
the way you might hope by Word.

If the data is in either HTML or RTF format, your best bet is probably to
export the data from each field (e.g. using Access VBA) into a separate file
with a .htm/.rtf extension, then use a nested INCLUDETEXT field to include
the file.

Peter Jamieson

"k0_zaw" wrote in message
...
I've Access database file, in which one table has richtext field inputting
data with leban's. When I use msword's mailmerge, database source to that
access file,
Notice that all are well, but that richtext filed show only some digits.

As far as surf on web, no answer found.
May be richtext filed don't support in word mailmerge.
Looking for the workaround.

My point is "want to insert data with text formatting in Access, and use
that data in word mailmerging."

Thanks in advance.
--
Zaw