Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
lkitajima lkitajima is offline
external usenet poster
 
Posts: 1
Default how do I format a filed as a percent in MS Office Word mail merge


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default how do I format a filed as a percent in MS Office Word mail merge

See: http://www.gmayor.com/formatting_word_fields.htm

--
Cheers
macropod
[MVP - Microsoft Word]


"lkitajima" wrote in message ...

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mike Mike is offline
external usenet poster
 
Posts: 229
Default how do I format a filed as a percent in MS Office Word mail me

Hello,
How do you do the alt-f9 in word 2007? I'm still having problems with the
above code. I get an "!Undefiend Bookmark, MERGEFIEL" error.
thanks
--
mike


"macropod" wrote:

See: http://www.gmayor.com/formatting_word_fields.htm

--
Cheers
macropod
[MVP - Microsoft Word]


"lkitajima" wrote in message ...


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default how do I format a field as a percent in MS Office Word mail me

Hi Mike,

Word 2007 is no different in this respect. The error message suggest you haven't followed the instructions correctly.
Try this approach:
.. select your mergefield, which will look something like «Amount»
.. press Ctrl-F9. You should now see something like { «Amount» }
.. edit between the field braces so that you get the equivalent of {=«Amount»*100 \# "0%"}
.. run your mailmerge

--
Cheers
macropod
[MVP - Microsoft Word]


"mike" wrote in message ...
Hello,
How do you do the alt-f9 in word 2007? I'm still having problems with the
above code. I get an "!Undefiend Bookmark, MERGEFIEL" error.
thanks
--
mike


"macropod" wrote:

See: http://www.gmayor.com/formatting_word_fields.htm

--
Cheers
macropod
[MVP - Microsoft Word]


"lkitajima" wrote in message ...



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mike Mike is offline
external usenet poster
 
Posts: 229
Default how do I format a field as a percent in MS Office Word mail me

Hi Macropod,
The F Lock was off so the alt-F9 and ctrl-F9 where not working...
Now that I figured that out my field looks like this:
{ MERGEFIELD Annual_Billing_Rate \# "#.###%" }
When I insert the second set of brackets via ctrl-F9 and type in the correct
equation and then do alt F9 my results come back blank. Any idea what I'm
doing wrong?
thanks
--
mike


"macropod" wrote:

Hi Mike,

Word 2007 is no different in this respect. The error message suggest you haven't followed the instructions correctly.
Try this approach:
.. select your mergefield, which will look something like «Amount»
.. press Ctrl-F9. You should now see something like { «Amount» }
.. edit between the field braces so that you get the equivalent of {=«Amount»*100 \# "0%"}
.. run your mailmerge

--
Cheers
macropod
[MVP - Microsoft Word]


"mike" wrote in message ...
Hello,
How do you do the alt-f9 in word 2007? I'm still having problems with the
above code. I get an "!Undefiend Bookmark, MERGEFIEL" error.
thanks
--
mike


"macropod" wrote:

See: http://www.gmayor.com/formatting_word_fields.htm

--
Cheers
macropod
[MVP - Microsoft Word]


"lkitajima" wrote in message ...






  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mike Mike is offline
external usenet poster
 
Posts: 229
Default how do I format a field as a percent in MS Office Word mail me

I got it - talk about touchy!!!
Thanks
--
mike


"mike" wrote:

Hi Macropod,
The F Lock was off so the alt-F9 and ctrl-F9 where not working...
Now that I figured that out my field looks like this:
{ MERGEFIELD Annual_Billing_Rate \# "#.###%" }
When I insert the second set of brackets via ctrl-F9 and type in the correct
equation and then do alt F9 my results come back blank. Any idea what I'm
doing wrong?
thanks
--
mike


"macropod" wrote:

Hi Mike,

Word 2007 is no different in this respect. The error message suggest you haven't followed the instructions correctly.
Try this approach:
.. select your mergefield, which will look something like «Amount»
.. press Ctrl-F9. You should now see something like { «Amount» }
.. edit between the field braces so that you get the equivalent of {=«Amount»*100 \# "0%"}
.. run your mailmerge

--
Cheers
macropod
[MVP - Microsoft Word]


"mike" wrote in message ...
Hello,
How do you do the alt-f9 in word 2007? I'm still having problems with the
above code. I get an "!Undefiend Bookmark, MERGEFIEL" error.
thanks
--
mike


"macropod" wrote:

See: http://www.gmayor.com/formatting_word_fields.htm

--
Cheers
macropod
[MVP - Microsoft Word]


"lkitajima" wrote in message ...




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
Word 2003 Mail merge - Inserting word filed if...then...else Mani K Mailmerge 2 April 20th 07 09:20 AM
Clarification CC Filed in Mail Merge Ashish Microsoft Word Help 2 August 27th 06 05:46 PM
Percent Format in when doing Mail merge mauro Mailmerge 1 March 8th 06 05:02 AM
Mail Merge Percent Format YanYan Mailmerge 3 February 16th 06 09:33 PM
formatting percent field using mail merge PamWilhite Mailmerge 3 February 19th 05 08:58 AM


All times are GMT +1. The time now is 06:09 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"