Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-29-2011, 09:19 AM
mike0919 mike0919 is offline using merge fields in "if then else" formula Windows 7 64bit using merge fields in "if then else" formula Office 2010 64bit
Novice
using merge fields in "if then else" formula
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing "Fill-In" merge fields vorm Mail Merge 0 07-27-2011 08:22 AM
using merge fields in "if then else" formula How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
using merge fields in "if then else" formula Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM
"Microsoft Excel Application" missing in the "Component Services" on win08 sword.fish Excel 0 02-26-2010 02:09 PM
merge field formatting problem with "text to be inserted before" wissam Mail Merge 0 12-13-2009 12:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft