A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Incorrect data returning during a merge



 
 
Thread Tools Display Modes
  #1  
Old June 17th, 2009, 02:28 AM posted to microsoft.public.word.mailmerge.fields
Tim
external usenet poster
 
Posts: 780
Default Incorrect data returning during a merge

Two part question:
1-I am trying to pull a currency value into a mail merge and the word
document leaves off the zeros, when there are zeros. I am a novice at merge
fields so in depth help is much appreciated
2-I am also doing a Dear "first_name" merge and the first name part I can't
seem to get the right size font. No matter what I do, it reverts to a 10 pt.
Please help.

THANKS IN ADVANCE!!
  #2  
Old June 17th, 2009, 05:41 AM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Incorrect data returning during a merge

To manage mailmerge number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
.. edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
.. position the cursor anywhere in this field and press F9 to update it.

Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include:
.. \# 0 for rounded whole numbers
.. \# ,0 for rounded whole numbers with a thousands separator
.. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
.. \# $,0 for rounded whole dollars with a thousands separator
.. \# $,0.00;($,0.00);'-' for currency, with brackets around negative numbers and a hyphen for 0 values

The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) zero values will be suppressed.
Note that this suppresses 0s resulting from empty fields and from fields containing 0s.

As for the first_name mergefield's formatting, you need to add a 'Charformat' picture switch to the mergefield. To do this:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD first_name};
.. delete everything between 'first_name' and the closing field brace;
.. add ' \* Charformat' after 'first_name', so that you end up with {MERGEFIELD first_name \* Charformat};
.. format at least the 'M' in 'MERGEFIELD' with the font attributes you want;
.. position the cursor anywhere in the field and press F9 to update it.

When you're done making the changes, run your mailmerge.

--
Cheers
macropod
[Microsoft MVP - Word]


"Tim" wrote in message ...
Two part question:
1-I am trying to pull a currency value into a mail merge and the word
document leaves off the zeros, when there are zeros. I am a novice at merge
fields so in depth help is much appreciated
2-I am also doing a Dear "first_name" merge and the first name part I can't
seem to get the right size font. No matter what I do, it reverts to a 10 pt.
Please help.

THANKS IN ADVANCE!!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.