Microsoft Office Forums - View Single Post - using merge fields in "if then else" formula

Thread: using merge fields in "if then else" formula

View Single Post

Old

07-29-2011, 09:19 AM

mike0919

mike0919 is offline

mike0919 uses Windows 7 64bit

Windows 7 64bit mike0919 uses Office 2010 64bit

mike0919 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jul 2011

Posts: 2

mike0919 is on a distinguished road

Default

using merge fields in "if then else" formula

I am trying to create an "if then else" formula in a mail merge but cannot find the correct syntax. I have tried:
{IF {MERGEFIELD LAST_CURRENT} = "" {MERGEFIELD LAST_HS} {MERGEFIELD LAST_CURRENT} }

Obviously, the above doesn't work. Any assistance would be greatly appreciated.

Last edited by mike0919; 07-29-2011 at 09:26 AM. Reason: Forgot one additional comment.

Reply With Quote