邮件合并问题 [英] Mail Merge Issue

问题描述

Hello All，

我已经做了很多浏览试图解决这个问题。 

我们运行邮件合并和帐号打印在诸如以下的字母上：0011 123456 7.所希望的是仅具有"3456"字母。打印。我尝试输入：
{MERGEFIELD Account_Number \＃00000 000000}只是尝试去除空格，然后也可以应用MOD。当我测试  然后填充的
数字甚至不匹配帐号。 

我尝试了其他方式：

{= MOD（{= {MERGEFIELD MyData} -1}，10000）+1}

{= MOD（{MERGEFIELD MyData}，10000）}

导致！缺少运算符或语法错误

有谁知道解决方案？感谢您的帮助。

我也无权修改数据。

解决方案

什么是数据源？一个Word表？一个Excel文件？一个数据库？

我怀疑你无法使用字段代码执行此操作，您可能需要使用源数据...

Hello All,

I have done a lot of browsing trying to solve this issue. 

We run a mail merge and the account number prints on letters such as: 0011 123456 7. What is desired is to have just the "3456" print out. I have tried entering: {MERGEFIELD Account_Number \#00000000000} to just try and get rid of the spaces so then a MOD could be applied as well. When I test this the number that is then populated does not even match the account number. 

I've tried other ways:

{=MOD({={MERGEFIELD MyData}-1},10000)+1}

{=MOD({MERGEFIELD MyData},10000)}

which have resulted in !Missing Operator or Syntax Error

Does anyone know of a solution? Thank you for your assistance.

I do not have access to altering the data either.

解决方案

What's the data source? A Word table? An Excel file? A database?

I suspect you're not going to be able to do this with field codes, you might have to work with the source data...

这篇关于邮件合并问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！