Word mail merge coming from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

slb - 19 Jan 2006 19:47 GMT

I have a complex spreadsheet with multiple calculations and am merging the
data into Word. When I run the merge, I lose all formatting of the numbers,
and about 10 decimal places print. I have added round functions to my
formulas, but still haven't completly solved the problem. How do I bring in
commas, dollar signs and only 2 decimal points when merging with Word?

Reply to this Message

Doug Robbins - Word MVP - 19 Jan 2006 19:53 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a complex spreadsheet with multiple calculations and am merging the
> data into Word. When I run the merge, I lose all formatting of the
[quoted text clipped - 3 lines]
> in
> commas, dollar signs and only 2 decimal points when merging with Word?

Reply to this Message

slb - 19 Jan 2006 21:38 GMT

Thank-you, I was having trouble getting the switches to work. I found the
following explanation which solved my problem and was easier. (I am working
in Office 2003). www.http://www.uwec.edu/help/WordXP/MM-withxls-m.htm

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 8 lines]
> > in
> > commas, dollar signs and only 2 decimal points when merging with Word?

Reply to this Message

Graham Mayor - 20 Jan 2006 07:51 GMT

The link you posted referred to a different solution entirely. You could
have found that solution elsewhere on my web site. For the formatting of
Word fields the switch method is easier, so I am puzzled why you found it
difficult. If you coulkd explain your difficulty maybe I could improve the
page to make it more accessible.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> Thank-you, I was having trouble getting the switches to work. I
> found the following explanation which solved my problem and was
[quoted text clipped - 22 lines]
>>> commas, dollar signs and only 2 decimal points when merging with
>>> Word?

Reply to this Message

Dean - 17 Aug 2006 18:59 GMT

Can you help me out. I have a similar problem with a mail merge and I can't
seem to use the web site you have indicated as my Word doesn't have the data
merge manager under tools. I can't solve the problem of reformatted my
numeric merge down to two decimal places. thanks for any assistance you can
provide.
my work email is dean@deckertleahy.com
thanks again,

Signature

Dean

> I have a complex spreadsheet with multiple calculations and am merging the
> data into Word. When I run the merge, I lose all formatting of the numbers,
> and about 10 decimal places print. I have added round functions to my
> formulas, but still haven't completly solved the problem. How do I bring in
> commas, dollar signs and only 2 decimal points when merging with Word?

Reply to this Message

Doug Robbins - Word MVP - 17 Aug 2006 21:14 GMT

I am not sure to what web site you are referring. Was it "Formatting Word
fields with switches" on fellow MVP Graham Mayor's
website at

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

Nor have you told us what version of Word you are using, not that it makes
any difference to the formatting of the fields, but as far as your problem
with the lack of what you refer to as "the data merge manager under tools"
on other pages on the above website you will find information on displaying
the mailmerge toolbar (View>Toolbars). Look at the page about merging to
labels with Word XP.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Can you help me out. I have a similar problem with a mail merge and I
> can't
[quoted text clipped - 15 lines]
>> in
>> commas, dollar signs and only 2 decimal points when merging with Word?

Reply to this Message

Peter Jamieson - 17 Aug 2006 22:10 GMT

Are you using Word for the Mac? If so, which version?

Peter Jamieson

> Can you help me out. I have a similar problem with a mail merge and I
> can't
[quoted text clipped - 15 lines]
>> in
>> commas, dollar signs and only 2 decimal points when merging with Word?

Reply to this Message