Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2003

Tip: Looking for answers? Try searching our database.

Mail merge problems with currency

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sonya - 07 Aug 2003 23:47 GMT
I am doing a mail merge from Word to Excel.  I am using
clean generic formatted numbers with 2 decimal places in
the original data source (And have even tried it with the
currency being formatted as text).

I close this and go to my Word and start the merge
process off of a blank document. When I preview my
document (which only contains two merge codes and no
other text or formatting then what is in my default
normal.dot, it extends my decimal place in my currency
field when I preview it.

Why is it doing this to my currency field.  I am not
adding in any more that a 2 decimal place number in my
data source and I still get this even when that column
has been formatted to recognize this number as text.  I
am at a loss.  What can I do to fix this?

You got me.@ the IT Help Desk
Graham Mayor - 08 Aug 2003 08:55 GMT
This is caused by the way Word now connects to Excel
See the relevant section at
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm
and http://www.gmayor.dsl.pipex.com/formatting_word_fields.htm for an
alternative workaround

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
  Web site www.gmayor.dsl.pipex.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am doing a mail merge from Word to Excel.  I am using
> clean generic formatted numbers with 2 decimal places in
[quoted text clipped - 15 lines]
>
> You got me.@ the IT Help Desk
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.