> { MERGEFIELD «Cardholder_Number»\# x### } works just like the RIGHT
> function in Excel and displays the last 4 digits of the cardholder
> number in my letter. Simple and no math!
>
> Thanks for your help and suggestions.
> Laurel
>
> "Laurel" wrote:
>
>> Thank you so much to you and Graham. I'm having trouble getting it
>> to work without syntax errors. I don't have a lot of experience with
>> mail merge. But while I was trying to figure it out, I came across a
>> numeric picture switch that drops digits to the left of the "x"
>> placeholder. I'm still unable to type without getting syntax errors
>> but theoretically would this work?
>>
>> { = 111053 + 111439 \# x## } displays "492". (example in
>> documentation) { = «Cardholder_Number»\# x### } (how it would maybe
>> work for me?)
>>
>> Also, I'm still unable to key this into my document so that it
>> works. I can get the brackets using Ctrl-F9 but everything I type
>> inside gets a syntax error.
>>
>> Thank you so much. You guys are great!
>>
>> "Peter Jamieson" wrote:
>>
>>> <<
>>> It seems like it should be
>>> just as simple as the RIGHT function in Excel
>>>>>
>>>
>>> It does, but unfortunately it isn't.
>>>
>>> If the account number is a whole number (or in some case, contains
>>> a whole number) not more than around 14 or so digits long, you can
>>> use
>>>
>>> { =mod({ MERGEFIELD youraccountfield },10000) } and prefix any
>>> asterixes you need.
>>>
>>> All the {} need to be the special field code braces that you can
>>> insert using ctrl-F9.
>>>
>>> If the account number is more complex there are two things you can
>>> do other than transform your data source into another format:
>>> a. use a DATABASE field - nasty, but see
>>>
http://tips.pjmsn.me.uk/t0004.htm b. use Word VBA to issue a SQL
>>> query to get the data from the .csv file, and put the necessary
>>> right() function in that query. That isn't straightforward either,
>>> but it can usually be done as long as the .csv can be read by the
>>> Jet ODBC driver/OLE DB provider and doesn't have more than 255
>>> fields.
>>>
>>> Peter Jamieson
>>>
>>>
>>> "Laurel" <Laurel[ at ]discussions.microsoft.com> wrote in message
>>> news:5DF29172-C6F5-4205-85C6-EEF2D7FB78EE[ at ]microsoft.com...
>>>> Hi All,
>>>> I'd like to print just the last 4 numbers of an account number in
>>>> a mail merge letter (front fill the rest with asterisks). It seems
>>>> like it should be
>>>> just as simple as the RIGHT function in Excel but by necessity my
>>>> source document has be a CSV text document so the function has to
>>>> take place in Word. Is this possible?
>>>>
>>>> Thanks so much!
>>>> Laurel