Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Conditional formatting of Mailmerge fields
I have some missing data in my database and want output documents to look
like printed forms with underlined blanks for these data. Have accomplished this by putting series of underscores in the fields in the Excel database. Would also like to highlight fields that need filled in to bring them to document user's attention. I can highlight the field in the document, but all results, even those that have values are highlighted. Is there a way to highlight a field in the document ONLY when a certain condition exists -- say the 2nd character in the field string is an underscore? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Conditional formatting of Mailmerge fields
Rather than having the underscores in the data source, you could use the
following field construction { IF { MERGEFIELD fieldthatmightbeempty } "" { MERGEFIELD fieldthatmightbeempty} { QUOTE "Please supply missing data" \* Charformat } } and format font to make the Q of QUOTE Red. If the field is empty, the text "Please supply missing data" will be inserted in the document in Red If you have the same number of underscores in each of the fields in the data source, you could use { IF { MERGEFIELD fieldthatmightbeempty } "____" { MERGEFIELD fieldthatmightbeempty} { QUOTE "____" \* Charformat } } where the number of _ in the first ____ equals that in the data source and then with the Q of QUOTE formatted as Red, the underscores in the merged document would also be Red. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "THE Burg" wrote in message ... I have some missing data in my database and want output documents to look like printed forms with underlined blanks for these data. Have accomplished this by putting series of underscores in the fields in the Excel database. Would also like to highlight fields that need filled in to bring them to document user's attention. I can highlight the field in the document, but all results, even those that have values are highlighted. Is there a way to highlight a field in the document ONLY when a certain condition exists -- say the 2nd character in the field string is an underscore? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Conditional formatting of Mailmerge fields
Hi Burg,
Doug's given some good advice. To test whether the second character is an undersco: {IF{MERGEFIELD Data}= "?_*" {QUOTE "Missing data" \* Charformat} {MERGEFIELD Data}} with the 'Q' in 'QUOTE' formatted per your conditional format. -- Cheers macropod [MVP - Microsoft Word] "THE Burg" wrote in message ... I have some missing data in my database and want output documents to look like printed forms with underlined blanks for these data. Have accomplished this by putting series of underscores in the fields in the Excel database. Would also like to highlight fields that need filled in to bring them to document user's attention. I can highlight the field in the document, but all results, even those that have values are highlighted. Is there a way to highlight a field in the document ONLY when a certain condition exists -- say the 2nd character in the field string is an underscore? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Conditional formatting of Mailmerge fields
Thanks to both of you -- that took care of it!
"macropod" wrote: Hi Burg, Doug's given some good advice. To test whether the second character is an undersco: {IF{MERGEFIELD Data}= "?_*" {QUOTE "Missing data" \* Charformat} {MERGEFIELD Data}} with the 'Q' in 'QUOTE' formatted per your conditional format. -- Cheers macropod [MVP - Microsoft Word] "THE Burg" wrote in message ... I have some missing data in my database and want output documents to look like printed forms with underlined blanks for these data. Have accomplished this by putting series of underscores in the fields in the Excel database. Would also like to highlight fields that need filled in to bring them to document user's attention. I can highlight the field in the document, but all results, even those that have values are highlighted. Is there a way to highlight a field in the document ONLY when a certain condition exists -- say the 2nd character in the field string is an underscore? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Wordart via Mailmerge-Field? | Mailmerge | |||
"Conditional formatting" in Word drop-down form fields | Microsoft Word Help | |||
Multiple Conditional Characters in Mailmerge | Mailmerge | |||
Conditional fields | New Users | |||
How do I set up a conditional page break in word mailmerge? | Mailmerge |