>I have a word template that has several fields replaced before being sent out. This is done using the search and replace functions:
>
>WITH oRange.Find
> .Replacement.Text = ALLTRIM(outfile.spec_inst)
> lFound = .Execute(,,,,,,,1,,,wdReplaceOne)
>ENDWITH
>
>This works fine for all my replacement fields. But this specific one is a memo field, and I guess someone finally filled it in past the string limit. I am getting: OLE lDispatch exception code from Microsoft Word: String parameter too long.
>
>What I am looking for is a work around or fix. So far I have found nothing besides going to a mail merge (which at this point I'm not sure I want to do). Any thoughts would be appreciated.
>
>Thanks,
>Kevin
Kevin,
You might try a few things :
-Try passing your string divided into smaller parts (255 chars but chose 250):
.Replacement.Text = lc250CharsPortion1+lc250CharsPortion2..lc250CharsPortionN
-Use copy&paste
_cliptext = ALLTRIM(outfile.spec_inst)
.ReplacementText = ""
.Execute(...)
oRange.Paste
etc.
PS: I didn't understand why you use find-replace for docvariables. You could directly set them. ie:
.Variables(cVarName).value = cValue
Cetin