Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Umtalipete Umtalipete is offline
external usenet poster
 
Posts: 1
Default Office 2003 Mail merge not preserving currency format

Just upgraded to Office 2003 and have a number of letters that merge data
extracted from an Access database, which includes fields with currency and
dates. In Office 2000 these functions all worked but in Office 2003 the dates
seem ok but the currency just comes over as a plain number eg entry in
database 175 displayed in database as £175.00 but in the word doc is just
plain 175 where as in 2000 it appeared as £175.00. The fields in the database
are set as currency. Any ideas on how to overcome this and why it happens?
Many Thanks
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Office 2003 Mail merge not preserving currency format

It occurs because
a. data and formatting are separated in Access
b. the default method Word uses to connect to Access data has changed from
"DDE" in Word 2000 to "OLEDB" in Word 2002/3/7
c. DDE gets the data from Access itself (which must be on your machine) and
delivers it more or less as you see it in many cases
d. OLEDB uses the underlying Jet database engine to get the data and
ignores the formatting.

You can either use "formatting switches" in your Word fields, e.g. use
Alt-F9 to show

{ MERGEFIELD myamount }

and change it to

{ MERGEFIELD myamount \#",0.00" }

That should be enough in simple situations.

Or you can check Word Tools|Options|General|"Confirm conversions at open",
go through the process of connecting to your data source again, and select
the DDE option when offered.

There are many differences between the two, but some you may need to take
note of at some point a
a. DDE doesn't pass non-ANSI Unicode characters through
b. OLEDB can't "see" certain types of query, e.g. parameter queries, and it
doesn't understand the old "*" and "?" wildcards in queries that use LIKE

Peter Jamieson

"Umtalipete" wrote in message
...
Just upgraded to Office 2003 and have a number of letters that merge data
extracted from an Access database, which includes fields with currency and
dates. In Office 2000 these functions all worked but in Office 2003 the
dates
seem ok but the currency just comes over as a plain number eg entry in
database 175 displayed in database as 175.00 but in the word doc is just
plain 175 where as in 2000 it appeared as 175.00. The fields in the
database
are set as currency. Any ideas on how to overcome this and why it happens?
Many Thanks



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Office 2003 Mail merge not preserving currency format

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

--

Graham Mayor - Word MVP

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


Umtalipete wrote:
Just upgraded to Office 2003 and have a number of letters that merge
data extracted from an Access database, which includes fields with
currency and dates. In Office 2000 these functions all worked but in
Office 2003 the dates seem ok but the currency just comes over as a
plain number eg entry in database 175 displayed in database as
175.00 but in the word doc is just plain 175 where as in 2000 it
appeared as 175.00. The fields in the database are set as currency.
Any ideas on how to overcome this and why it happens? Many Thanks



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency format - Excel to Word Merge ckkelliej Microsoft Word Help 1 November 29th 05 03:15 AM
Access currency field wont format correctly in word mail merge Marnee Mailmerge 3 June 2nd 05 05:40 AM
Currency fields in Access lose th currency format whn merged why PMasters Mailmerge 1 June 1st 05 08:13 PM
How do I format numbers as Currency via Mail Merge? SteveL67 Mailmerge 1 March 3rd 05 05:32 PM
How do I format a merge field as Currency or %? hmj3b5 Mailmerge 1 February 22nd 05 08:07 AM


All times are GMT +1. The time now is 04:18 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"