How can you get the dollar amounts including comma to transfer from Excel
2007 to a word document for mail merge?

One way is to copy what is in Excel and paste it into Word. It will paste as
a table.
ADBSeeker

"Kelly" wrote:

How can you get the dollar amounts including comma to transfer from Excel
2007 to a word document for mail merge?

I'm not sure all of this applies to Office 2007, but the last suggestion will
work.

Saved from a previous post:

Lots of times, it's easier to use MSWord for printing and Excel (or some other
database application) as the source.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

And if you notice problems with the formatting of data (like zipcodes)...

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

Kelly wrote:

How can you get the dollar amounts including comma to transfer from Excel
2007 to a word document for mail merge?

--

Dave Peterson

Hi Kelly,

To control 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;
.. 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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Kelly" wrote in message ...
How can you get the dollar amounts including comma to transfer from Excel
2007 to a word document for mail merge?

Not much use for a mailmerge though ...

--
Cheers
macropod
[Microsoft MVP - Word]


"ADB_Seeker" wrote in message ...
One way is to copy what is in Excel and paste it into Word. It will paste as
a table.
ADBSeeker

"Kelly" wrote:

How can you get the dollar amounts including comma to transfer from Excel
2007 to a word document for mail merge?