DDE does not appear to work correctly with Word and Access

[Dominic]

Hi,
I have created my merge document that uses an Access Query from a
database created in Access 2002 (as a 2000 database). When I run the
Mail Merge using DDE the Merge Fields in the database which are
formatted to UpperCase and of type TEXT, do not appear in UpperCase in
the merged document. They appear as LowerCase (which is how they are
in the database without formatting). I have formatted the TEXT fields
with the > symbol in the database, this produces nicely UpperCase TEXT
fields in the Table and Query. The DDE connection is supposed to
"Merge data with formatting" however this does not appear to work
correctly. Either DDE works on formatted TEXT fields or not! I am open
to suggestions for a workaround to produce UpperCase TEXT from a
database with LowerCase. I have tried using the Upper switch inserted
into the merge field (noted on Cindy Meister's Web page) however it
disappears after I type it into the merge field and click outside
it??? This happens when using Microsoft Office XP 2002. Any help would
be appreciated.

Regards
Dominic

 

[Cindy Meister -WordMVP-]

Hi Dominic,

I am open
to suggestions for a workaround to produce UpperCase TEXT from a
database with LowerCase. I have tried using the Upper switch inserted
into the merge field (noted on Cindy Meister's Web page) however it
disappears after I type it into the merge field and click outside
it???

You need to press Alt+F9 to display the merge field CODE, add the switch
just before the closing } bracket. Then Alt+F9 when you're done to
switch back to the field result display.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail