hello
i have issue with mail merge. after mail merge
I have a table as bellow

Category Data Spec
name 1 80 90~100
name 2 90 90~100
name 3 100 90~100
name 4 110 90~100
name 5 70 90~100

With data outspec, I want underline text as

Category Data Spec
name 1 80 90~100
name 2 90 90~100
name 3 100 90~100
name 4 110 90~100
name 5 70 90~100

Please help me
thank you very much

You could use a compound field coded as:
{=({MERGEFIELD Data}<90)+({MERGEFIELD Data}>110) \# "'{MERGEFIELD Data \# 0}';;'{MERGEFIELD Data}'"}
or
{=(«Data»<90)+(«Data»>110) \# "'{MERGEFIELD Data \# 0}';;'«Data»'"}
Note the underlined 0.

Note: The field brace pairs (i.e. '{ }') for the above examples are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field constructions are all required.

For a macro to convert the above field code representation into a working field code, see Convert Text Representations of Fields to Working Fields in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank for your support
But I have tried to do it but I can't
Please hep me

Attached Files

	Data.xlsx (8.3 KB, 3 views)
	Mail Merge.docx (14.0 KB, 3 views)

Aside from the fact that the field names in your workbook aren't what you put in your post, you Word document bears no evidence that you've even tried to implement the solution I posted.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Sorry. i will resend file this evening

Hello Mr
I am sorry about my mistake. I mixing about "{}"
I try to do again and i do with form
{ =(«RS»>90)+(«RS»>110) \# “’«RS»’;;’ «RS»’” }
And result is OK
Thank for your support

Attached Images

Result.png (3.5 KB, 2 views)