We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Changing the FONT of Chinese test in a table.

AbhijeetChib
8 - Asteroid

Hello Everyone. 

 

I have a business requirement where I need to send mass emails in Chinese. The email has text in Chinese followed by a table of some contacts followed by another table which has a lot of data. Everything is working alright but now the requirement is to change the Chinese text to a particular font which is "Chinese, 楷体 11"

 

I am creating a section in formula tool for the Chinese text "

 

"亲爱的用户,<br /><br />

您好!您收到这封邮件是因为您负责的采购订单存在收货与发票不匹配 (GRIR mismatch) 的情况。以下是截至上月底尚未解决 GRIR 问题的采购订单清单。其中金额为负数的代表收货(GR),需要您提供发票,金额为正数的代表发票(IR),需要您做收货。请参照以下数据来采取适当的行动"

AbhijeetChib_0-1753253670110.png

 

This is working as expected and the out if fine as shown below, but I need the text to be in "Chinese, 楷体 11"  font. 

AbhijeetChib_1-1753253958601.png

 

Any ideas ?

 

3 REPLIES 3
PangHC
13 - Pulsar

[not tested] Based on my basic html knowledge. you can try this add a style inside a tag, suggest <span> where no side effect as other tag.


"<span style="font-family: 'KaiTi', '楷体', serif; font-size: 11px;">亲爱的用户,<br /><br />

您好!您收到这封邮件是因为您负责的采购订单存在收货与发票不匹配 (GRIR mismatch) 的情况。以下是截至上月底尚未解决 GRIR 问题的采购订单清单。其中金额为负数的代表收货(GR),需要您提供发票,金额为正数的代表发票(IR),需要您做收货。请参照以下数据来采取适当的行动</span>"


of course you can add more to cover the table as well.

</ span>

<span style="font-family: 'KaiTi', '楷体', serif; font-size: 11px;">
<!--[table]-->
<!--[rows]-->
<!--[rows]-->


thanks,
</ span>
AbhijeetChib
8 - Asteroid

@PangHC  thanks for the response. 

 

Does this go to the formula tool ? I am getting an error - An operator must be between operands

 

AbhijeetChib_0-1753261512246.png

 

PangHC
13 - Pulsar

[Tested]. it work in Outlook. 

Spoiler
Screenshot 2025-07-23 182640.png
edit: i open it again today. it look the font is correct now. 

Screenshot 2025-07-24 144207.png

note: the list "'KaiTi', '楷体','Microsoft YaHei','SimSum',serif" mean if first not found, search for next font type. 

# when the text is mix of ' and ", simple way is to do  use '' to add " and use "" to add '.
'<span style="' + "font-family: 'KaiTi', '楷体','Microsoft YaHei','SimSum',serif; font-size: 20px;" + '">'




Screenshot 2025-07-23 182421.png

Labels
Top Solution Authors