Mail Merges in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ann - 12 Jul 2006 15:42 GMT

I'm trying to merge a word document (form letter) with data from a downloaded
Excel database (over 1,500) records. My problem is that I have to merge
various dollar amounts with the letter and after the letters are all merged
there are spaces between the dollar sign and the dollar amount. The command
I'm using currently is Pledge_Amount\# $#,###.00. As long as the dollar
amount is above $1,000.00 it's ok, but when it's below $1,000.00 then there
are extra spaces. Ex. $ 250.00, $ 37.00, $ 5.00. How do I get the dollar
amount next to the dollar sign with using a different switch for each dollar
amount? Any help is appreciated.

Signature

Ann

Reply to this Message

Peter Jamieson - 12 Jul 2006 17:49 GMT

You only need
Pledge_Amount \# "$,0.00"
or even
Pledge_Amount \# "$,.00"

The "," just tells Word to group by thosands using a comma - you do not have
to put it in the "correct" position in the format for it to work, so you
don't need all those extra "#" signs.

Peter Jamieson

> I'm trying to merge a word document (form letter) with data from a
> downloaded
[quoted text clipped - 11 lines]
> dollar
> amount? Any help is appreciated.

Reply to this Message

Ann - 12 Jul 2006 20:08 GMT

Peter,

Thank you so much!!!! You don't know how much time you have saved me every
month when I have to do this part of my job.

Signature

Ann

> You only need
> Pledge_Amount \# "$,0.00"
[quoted text clipped - 22 lines]
> > dollar
> > amount? Any help is appreciated.

Reply to this Message