Re: Modifying mergefield string contents

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

> I am trying to modify the contents of a mail merge field. Basicall, I
> need to strip the first two characters and the last 5 characters from a
> particular field:
>
> e.g. "P:ABC123(NNN)" strip off P: and (NNN)
>
> Unfortunately, the query that retrieves this data is automatically
> generated and can't be modified. Any ideas?
>
You'll need to either have that query modified, or import the data into
an application where you can modify it before using it for mail merge.
Into Excel, for example, where you could insert an additional column and
use functions on the data to return the result you want.

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 :-)

.

Relevant Pages

  • Modifying mergefield string contents
    ... I am trying to modify the contents of a mail merge field. ... Basicall, I ... need to strip the first two characters and the last 5 characters from a ...
    (microsoft.public.word.mailmerge.fields)
  • ANN: vile 9.6
    ... Vile is a text editor which is extremely compatible with vi. ... buffer when closes, ... modify manfilt.c to provide UTF-8 output in a UTF-8 locale. ... winvile - multicolumn characters, depends on font selection ...
    (comp.editors)
  • Re: Ligatures [was: Re: The -s plural in English nouns]
    ... Agent newsgroup where you could raise the point and see if ... ASCII characters, either of the things you've mentioned ... I never said anything about my using Lynx; ... commenting on with respect to looking in an Agent newsgroup ...
    (alt.usage.english)
  • Re: How to Limit Memo to 1500 Characters
    ... Something like "Please enter less than 1500 characters." ... In Design view, select the memo field. ... Now if you wish to use a Validation rule you can. ... Please respond only to this newsgroup. ...
    (microsoft.public.access.forms)
  • Re: Styles wont change
    ... To clarify what Charles is saying: you can modify a built-in style (see ... please post all follow-ups to the newsgroup so ...
    (microsoft.public.word.docmanagement)