Print only part of a merged field 2

[Cozmo2]

In the mail merge feature in Word 2010 how would I print a portion of a field? I have a mergefield called 'termint' with a value of YYYYMM. I want to print only the YYYY portion.
Thanks in advance for any help you can give!

 

[SkipVought]

Can't. The Merge Field is an entity. Uneditable.

Whee is the SOURCE table?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Cozmo2]

on a database server.

 

[SkipVought]

Is it a TEXT file, an Access DB, an Excel, a Word Table????

WHAT?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Cozmo2]

SQL table

 

[SkipVought]

Add a column to your SQL Server table for that truncated value or run a query that returns a column for that truncated value, for your mail merge.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Cozmo2]

Thanks, I'll put the wheels in motion to get this done.
Thanks.

 

[macropod]

You can do this without changing your data, using field coding:
{=INT({MERGEFIELD termint}/100) \# 0000}
or:
{=INT(«termint»/100) \# 0000}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.

Cheers
Paul Edstein
[MS MVP - Word]

 

[Cozmo2]

Thanks Paul, it worked like a charm!