Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Help with Word 2007[_2_] Help with Word 2007[_2_] is offline
external usenet poster
 
Posts: 4
Default Putting Mail Merge fields into excel tables in Word

Am still trying to fix my problem and going down this path now but even this
doesnt seem to work. Can anyone help? I am trying to put a mail merge field
into an excel table in a word document?

Fundamentally I am still just trying to format numbers from 1057 to $10.57
in the table so if there are other methods please let me know.
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Putting Mail Merge fields into excel tables in Word

Hi,

No, you can't put a mergefield into an Excel worksheet embedded in a Word document. In any event, it's quite unnecessary - all you
need to do is to apply the appropriate formatting 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;
.. run your mailmerge.

Note: The '\# $,0.00' 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 controlled 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.

NOTE: It helps if you give your questions a context. Your previous post gave no indication you were trying to perform a mailmerge,
for which field formatting switches (fully documented in Word's Help file) provide a ready answer.

--
Cheers
macropod
[Microsoft MVP - Word]


"Help with Word 2007" wrote in message
...
Am still trying to fix my problem and going down this path now but even this
doesnt seem to work. Can anyone help? I am trying to put a mail merge field
into an excel table in a word document?

Fundamentally I am still just trying to format numbers from 1057 to $10.57
in the table so if there are other methods please let me know.


  #3   Report Post  
Posted to microsoft.public.word.tables
Help with Word 2007[_2_] Help with Word 2007[_2_] is offline
external usenet poster
 
Posts: 4
Default Putting Mail Merge fields into excel tables in Word

Hi,

Thanks for the answer. It worked well.

"macropod" wrote:

Hi,

No, you can't put a mergefield into an Excel worksheet embedded in a Word document. In any event, it's quite unnecessary - all you
need to do is to apply the appropriate formatting 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;
.. run your mailmerge.

Note: The '\# $,0.00' 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 controlled 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.

NOTE: It helps if you give your questions a context. Your previous post gave no indication you were trying to perform a mailmerge,
for which field formatting switches (fully documented in Word's Help file) provide a ready answer.

--
Cheers
macropod
[Microsoft MVP - Word]


"Help with Word 2007" wrote in message
...
Am still trying to fix my problem and going down this path now but even this
doesnt seem to work. Can anyone help? I am trying to put a mail merge field
into an excel table in a word document?

Fundamentally I am still just trying to format numbers from 1057 to $10.57
in the table so if there are other methods please let me know.


.

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
Putting data from two different MSQL tables on one Mail Merge docu Nasty Cough Mailmerge 1 May 16th 09 09:38 PM
mail merge putting fields in the wrong place! Disa Mailmerge 1 September 18th 06 09:24 AM
mail merge keeps putting in decimals that are not on excel sheet eazy01 Mailmerge 1 August 24th 06 06:17 PM
Word mail merge to Excel fields reman Microsoft Word Help 1 June 10th 06 06:58 AM
Fields in Excel not found in Mail Merge, Word Jean Accola Mailmerge 0 November 22nd 05 05:17 AM


All times are GMT +1. The time now is 02:40 PM.

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

About Us

"It's about Microsoft Word"