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