Mailings - Conditional Check Box.

Christopher Holscher Larsen 20 Reputation points
2024-05-21T07:33:17.41+00:00

Hi everyone,

I have tried to find out how to create a conditional checkbox to no avail.

My goal is to check the right box in a word document depending on what a value is in a field in an excel file.

So if FieldValue = 1 Then Check Box 1 (Red Smily)

So if FieldValue = 2 Then Check Box 2 (Yellow Smily)

So if FieldValue = 3 Then Check Box 3 (Green Smily)

Billede

How would I go about this? It's easy to insert raw text and I can figure out that rulings can be created as an IF statement, but I have no idea how to code this.

Hope someone out the has a solution to this or can point me in the right direction.

Thanks. :)

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,695 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,963 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
930 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua-MFST 10,560 Reputation points Microsoft Vendor
    2024-05-22T05:30:55.3533333+00:00

    Hi @Christopher Holscher Larsen

    In my opinion, you need the assistant of VBA code.

    Here is one similar thread: Use conditional formatting in Word to change text color to gray after ticking checkbox


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.