Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 24 of 24

Thread: Mail Merge - Conditional formatting of cell background color

  1. #21
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,123
    Location
    The answer is simple: repeat all of the static text inside each field.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  2. #22
    VBAX Regular
    Joined
    Mar 2019
    Posts
    7
    Location
    Quote Originally Posted by macropod View Post
    The answer is simple: repeat all of the static text inside each field.
    The additional text isn't static, it's other mail merge fields.

  3. #23
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,123
    Location
    Quote Originally Posted by AbbyPi View Post
    The additional text isn't static, it's other mail merge fields.
    So replicate those mergefields, too. This isn't rocket science... And, as I said in post 12:
    All your attachment is is an image. There is no way anyone can assess what you've done from that
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #24
    VBAX Newbie
    Joined
    Sep 2020
    Posts
    1
    Location

    Mail Merge Conditional Formatting Cell Background Coloud

    Hi All,

    I followed the instructions above and use this as a reference:

    {IF{MERGEFIELD Condition}= "HIGH" "→→↵
    →→↵
    →→" \* Charformat}{IF{MERGEFIELD Condition}= "MID" "→→↵
    →→↵
    →→" \* Charformat}{IF{MERGEFIELD Condition}= "LOW" "→→↵
    →→↵
    →→" \* Charformat}

    I've set the margins (all sides) to 0, the tab is set to cell width, it's right-aligned, I use TAB (ctrl-TAB) because it's inside the cell, and for RETURN (shift-enter).but all I got is "Unknown Switch Argument". Please help

    Here's a screenshot of current work. I highlighted them to show the tabs.

    mailmerge cell colour.jpg
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •