Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-19-2012, 01:57 AM
macropod's Avatar
macropod macropod is offline Mail Merge in Word: creating a rule for blanks Windows 7 64bit Mail Merge in Word: creating a rule for blanks Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Claudia,

{MERGEFIELD Salary_Add \b "Shift Allowance/Salary Addition €" \f "¶
"}

However, if you need any particular numeric formatting in the mergefield, you'll need a different approach, as it seems Word can't apply numeric formatting along with the \b and \f switches. Instead, you can use an IF field test, constructed along the lines of:
{IF{MERGEFIELD Salary_Add }<> "" "Shift Allowance/Salary Addition { MERGEFIELD Salary_Add \# €,0.00}¶
"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
merge rules, word 2007



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge in Word: creating a rule for blanks I need MS Word Mail Merge Help! mikecincotta Mail Merge 1 10-04-2010 05:22 PM
Need help creating a data base for mail merge. acedking90 Mail Merge 0 07-27-2009 11:04 AM
using word/able to fill blanks w/o moving rest Rath Word 3 03-07-2009 08:46 AM
Mail Merge in Word: creating a rule for blanks Word 2007 Mail Merge halfempty Mail Merge 1 03-03-2009 07:45 PM
mail merge in word help jngovols Mail Merge 0 04-07-2008 05:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 AM.


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