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. :)

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Word | For business | Windows
0 comments No comments
{count} votes

Answer accepted by question author
  1. Jiajing Hua 18,125 Reputation points Moderator
    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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.