switches

[Ann]

I'm trying to merge a word document (letter) with data from an 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 my dollar amount is above
$1,000.00 it's ok, but when it's below that there are extra spaces.Ex. $
250.00, $ 5.00,
$ 23.00. How do I get the dollar amount next to dollar sign without using
a different switch for each dollar amount? Any help is appreciated. So much
for buying the Microsoft Office Excel 2003 and Microsoft Office Word 2003
books. They weren't helpful at all. Thanks.

Ann

 

[Bob Buckland ?:-\)]

Hi Ann,

You may want to also post this in the MS Word Mailmerge newsgroup using the link below .

======
I'm trying to merge a word document (letter) with data from an 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 my dollar amount is above
$1,000.00 it's ok, but when it's below that there are extra spaces.Ex. $
250.00, $ 5.00,
$ 23.00. How do I get the dollar amount next to dollar sign without using
a different switch for each dollar amount? Any help is appreciated. So much
for buying the Microsoft Office Excel 2003 and Microsoft Office Word 2003
books. They weren't helpful at all. Thanks.

Ann>>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com