Memo fields (multi line text) and Microsoft Word 2002

Memo fields (multi line text) and Microsoft Word 2002 - text data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newschapmj1 - 21 May 2008 09:24 GMT

Is there a way to include Memo fields in text data sources?

Reply to this Message

Doug Robbins - Word MVP - 21 May 2008 09:47 GMT

Tell us the full story. Where is the data at the moment? From where is the
text for the "Memo fields" coming?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is there a way to include Memo fields in text data sources?

Reply to this Message

newschapmj1 - 21 May 2008 11:05 GMT

On May 21, 9:47 am, "Doug Robbins - Word MVP"
<d...@REMOVECAPSmvps.org> wrote:

> Tell us the full story. Where is the data at the moment? From where is the
> text for the "Memo fields" coming?
[quoted text clipped - 8 lines]
>
> > Is there a way to include Memo fields in text data sources?

Thanks for the swift response.

We have written an application that collects data from a sql 2000
database and then writes the data to a text file (relates to a single
letter).
If calls macros in Word and gets Word to do a mail merge for a single
letter at a time.
This works fine and is reliable.

So far all our data items are short data items with no carriage
returns in them.
I'd like to include multi line text if this is possible (typically 4-8
lines of text, 100-400 characters).

Would it would work if we used an Access record instead?

Reply to this Message

Doug Robbins - Word MVP - 21 May 2008 12:55 GMT

You still haven't advised where the text for the memo originates, but
certainly, a memo field from access can be merged into a Word document. In
some cases, people have reported truncation of data, but that can be
overcome by changing the method of connection of the data source to the mail
merge main document.

For an application producing one letter at a time, I would probably not use
mailmerge. Rather, I would use a template with DOCVARIABLE fields in place
of mergefields and then have code create a new document from the template
and create variables in the document that contains the values from the data
source and then update the fields in the document so that the fields display
the values of the variables.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> On May 21, 9:47 am, "Doug Robbins - Word MVP"
> <d...@REMOVECAPSmvps.org> wrote:
[quoted text clipped - 27 lines]
>
> Would it would work if we used an Access record instead?

Reply to this Message