MS Word VBO - Mail Merge with IF Statement

Yihang — Thu, 18 May 2023 15:35:00 GMT

Hi guys,

I am not sure if this question has been asked before - but I am trying to use the MS Word VBO: Mail Merge action to input data into a word document template with defined fields. The action works well until I try to deal with a check box. Here is the document template looks like:

The first two merge fields (Name & Address) could be successfully entered using the VBO, but I can't use the VBO to modify the checkbox for "Status". I tried to manually change the «Checkbox - Single» in word into "True" or "False", and the checkbox symbol could be correctly displayed, but if I use the VBO, the output will look like this:

Basically the VBO is adding a text "True" in front of the "IF" merge field and the symbol will always be unchecked. Any chance someone has a solution to check the checkbox using the MS Word VBO?

Thanks,
Yihang

------------------------------
Yihang Tong
------------------------------

RE: MS Word VBO - Mail Merge with IF Statement

ewilson — Mon, 22 May 2023 15:43:00 GMT

@Yihang

You're seeing "True" inserted because the Merge Mail action only supports writing text at the moment. You might be able to add some extra code to the Code stage to perform a InsertSymbol call on the selection. I haven't tested it, so I can't say if it will actually work. You would also need to include something in the input data to identify that the field needed to be handled as a checkbox as opposed to text.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

topic RE: MS Word VBO - Mail Merge with IF Statement in Product Forum

MS Word VBO - Mail Merge with IF Statement

RE: MS Word VBO - Mail Merge with IF Statement