制作带表格的邮件模板（将word格式的转为HTML)

太过爱你忘了你带给我的痛 2023-10-10 04:24 23阅读 0赞

### 原始资料 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70][]

### 一、将内容拷贝包word ###

按住shift+F3转成大写（转换成小写方法一样）

\{ \{ \}\}是邮件模板中需要替换的格式（变量）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 1][]

### 2.word转html（将以上内容拷贝到） ###

[https://wordhtml.com/][https_wordhtml.com]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 2][]

因为标题拷贝过来有的会丢失字符大小，重新设置即可

<p>A new Investment</p>
    <p>Review request has been submitted</p>
    <table>
    <tbody>
    <tr>
    <td width="355">
    <p><strong><strong>End Customer Name </strong></strong></p>
    </td>
    <td width="355">
    <p>{
       {END_CUSTOMER_NAME}}</p>
    </td>
    </tr>
    <tr>
    <td width="355">
    <p><strong><strong>End Customer Number</strong></strong></p>
    </td>
    <td width="355">
    <p>{
       {END_CUSTOMER_NO}}</p>
    </td>
    </tr>
    </tbody>
    </table>
    <p> </p>

添加表格的宽度 <table border=\\\\\\"1\\\\\\">   其中 \\\\\\" 转义字符

在其中有一些需要删除

如 width="355"

![20190924112838497.png][]

![20190924112945652.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 3][]

![20190924115956591.png][]

点击对号后clean可以去除

点击 compress 压缩后

<p>A new Investment</p><p>Review request has been submitted</p><table><tbody><tr><td width="355"><p><strong><strong>End Customer Name </strong></strong></p></td><td width="355"><p>{
       {END_CUSTOMER_NAME}}</p></td></tr><tr><td width="355"><p><strong><strong>End Customer Number</strong></strong></p></td><td width="355"><p>{
       {END_CUSTOMER_NO}}</p></td></tr></tbody></table>

### 3.代码测试 ###

菜鸟HTML运行

[https://www.runoob.com/try/try.php?filename=tryhtml\_intro][https_www.runoob.com_try_try.php_filename_tryhtml_intro]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 4][]

然后利用excel模板insert数据库即可

### 备注： ###

1.也可利用.nodepad++

\\r\\n替换为空格（行尾符号）

2.其余功能：![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 5][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190924112102971.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190924112201323.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx,size_16,color_FFFFFF,t_70
[https_wordhtml.com]: https://wordhtml.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2019092411234586.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx,size_16,color_FFFFFF,t_70
[20190924112838497.png]: https://img-blog.csdnimg.cn/20190924112838497.png
[20190924112945652.png]: https://img-blog.csdnimg.cn/20190924112945652.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20190924115749405.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx,size_16,color_FFFFFF,t_70
[20190924115956591.png]: https://img-blog.csdnimg.cn/20190924115956591.png
[https_www.runoob.com_try_try.php_filename_tryhtml_intro]: https://www.runoob.com/try/try.php?filename=tryhtml_intro
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20190924122531950.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20190924120334580.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Z3azE5ODQwMzAx,size_16,color_FFFFFF,t_70