Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-12-2015, 11:36 AM
AJ345 AJ345 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2015
Posts: 3
AJ345 is on a distinguished road
Default Switches disappear

Hi, I'm trying to format a numeric mailmerge field.

After many tries, I got it to retain this:
{ MERGEFIELD \# $,0 ContribTotalAmount }

Now I'm trying to add the ".00"

I go into the field and change it to :
{ MERGEFIELD \# $,0.00 ContribTotalAmount }

I preview results, or toggle field codes, and he number appears without the decimal point and last two digits. I re-toggle and I'm back to:
{ MERGEFIELD \# $,0 ContribTotalAmount }

I've also tried:
{ MERGEFIELD \# $,0.00 \*MERGEFORMAT ContribTotalAmount }

Sometimes when I toggle the first time it works, but disappears when I do the merge.



This has happened with every field I've tried to format - dates, etc. I've tried it with and without quotes. After awhile, I get it to take, but I never know why. Please help!!
Reply With Quote
  #2  
Old 03-13-2015, 12:15 AM
gmayor's Avatar
gmayor gmayor is online now Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,128
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

{ MERGEFIELD ContribTotalAmount \# $,0.00 }
or
{ MERGEFIELD "ContribTotalAmount" \# $,0.00 }

should give you the result you require. Don't forget to update the field
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-13-2015, 08:00 AM
AJ345 AJ345 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2015
Posts: 3
AJ345 is on a distinguished road
Default

Thanks. Are you saying I need to put the switch at the end? If not, please explain how what you have differs from what I have?

Also, when you say update the field, can you tell me what sequence I should use? I entered the switch as you have it, { MERGEFIELD ContribTotalAmount \# $,0.00 }, then saved the doc. Then I right-clicked, clicked Update Field, and it goes back to $1,000 without the .00. Toggling field codes reveals it to be { MERGEFIELD \# $,0 ContribTotalAmount } - right back to what I had before. Are you using office 2013?

I appreciate your help.
Reply With Quote
  #4  
Old 03-13-2015, 08:13 AM
gmayor's Avatar
gmayor gmayor is online now Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,128
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

The conventional wisdom is that the switches go at the end of the field structure.

There is no mechanism whereby a field can revert to a previous description unless there is some document corruption, and this is true whether you use 2013 or any earlier version. The principles involved are the same.

There is clearly a problem with this document. I suspect that there is an orphan lock file involved. Close the document. Close Word. Check in Windows Task manager (CTRL+SHIFT+ESC) that the process Winword.exe is no longer running. If it is, close it from the dialog.

Reboot the PC.

See http://www.gmayor.com/what_to_do_when_word_crashes.htm with respect to orphan lock files.

Restart Word and open the merge document. From the mailings tab, set the document type to Normal Word Document and then re-attach the data source.

Does it behave normally now?
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 03-13-2015, 08:18 AM
AJ345 AJ345 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2015
Posts: 3
AJ345 is on a distinguished road
Default

I've done it all. Many times. Done it on multiple PCs and with multiple docs. I think it is a buggy piece of CRAP.

Having said that, I just got it to work. I hit alt/F9, edited it manually, put in the \*MERGEFORMAT switch manually, hit alt/F9, then merged, and it was retained.

Thanks for your patience and for allowing me to vent
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems With MergeField Switches JennEx Mail Merge 56 04-28-2013 06:40 PM
Switches ilovemypuppy Word 2 02-08-2012 04:28 PM
Index switches cksm4 Word VBA 2 02-03-2011 07:21 AM
Mail merge switches Jan Collier Word 0 08-29-2010 06:06 AM
Command Line Switches Ringmaster Office 0 08-10-2010 06:27 AM


All times are GMT -7. The time now is 02:38 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft