Including partial document name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AGI - 12 May 2004 18:12 GMT

Is it possible to include only the first 9 characters of
the full document name as a merge field? i.e Document name
is "ABCD-1234-Test document.doc" Merge field value should
be "ABCD-1234".

Reply to this Message

Doug Robbins - Word MVP - 12 May 2004 23:52 GMT

Not possible as part of the merge process. It would have to be done by
manipulation of the datasource. If it's an Access database, by means of a
query that uses the Left() function in an express; if it's Excel, use the
=Left() function, If it's a Word table, a macro that stepped through the
rows of the datasource, using the Left() function/

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Is it possible to include only the first 9 characters of
> the full document name as a merge field? i.e Document name
> is "ABCD-1234-Test document.doc" Merge field value should
> be "ABCD-1234".

Reply to this Message