![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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] |
#3
|
|||
|
|||
![]()
Thank for your support
But I have tried to do it but I can't Please hep me |
#4
|
||||
|
||||
![]()
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] |
#5
|
|||
|
|||
![]()
Sorry. i will resend file this evening
|
#6
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Swarup | Word | 11 | 07-26-2022 01:51 PM |
Replacing a comment with underline or other formatting (or adding that formatting to commented text) | paulkaye | Word | 4 | 05-16-2016 05:38 AM |
![]() |
Keokira | Word | 1 | 04-07-2016 08:22 AM |
![]() |
Instructor Mark | Word | 4 | 04-06-2016 01:32 PM |
![]() |
sential | Word | 6 | 01-10-2014 03:22 PM |