Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John Pronk
 
Posts: n/a
Default What is the correct syntax to format merged fields?

When adding fields to a merge document, Microsoft Office Online suggests
using switches {MergeAmount /# $#,###.00} to format the number into the way I
want to display it. Whenever I enter this in my merge field in the document,
the field Amount does not get formatted. How do I get the merge field to
accept the formatting?

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default What is the correct syntax to format merged fields?

Office OnLine didn't suggest that switch or construction!
You want {Mergefield Amount \# "$,0.00"}
Use CTRL+F9 for the curly brackets
See http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


John Pronk wrote:
When adding fields to a merge document, Microsoft Office Online
suggests using switches {MergeAmount /# $#,###.00} to format the
number into the way I want to display it. Whenever I enter this in my
merge field in the document, the field Amount does not get
formatted. How do I get the merge field to accept the formatting?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set max field length of merged fields? chiefcook Mailmerge 1 September 25th 05 07:05 AM
Access2003 fields merged to Word 2000 Emmy Microsoft Word Help 1 February 17th 05 10:37 AM
Mailmerge in Word, date format in merged doc brownsox Mailmerge 2 January 14th 05 12:29 PM
how to format phone number merged fields? GMed Mailmerge 1 December 9th 04 09:49 PM
Format a merged numeric field Hema Mailmerge 1 December 8th 04 12:51 AM


All times are GMT +1. The time now is 11:34 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"