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 / April 2006

Tip: Looking for answers? Try searching our database.

Excel superscript not holding

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brenda Rueter - 25 Apr 2006 12:51 GMT
User has Excel and Word 2002, SP-3

User is merging from an Excel database which has some items formatted as
superscript, such asthe 2 in H2O.  When merged into a Word document the
superscript formatting is lost.  We do have "Confirm Conversion at Open"
checked and are using DDE to do the merge.  Any ideas why the formatting
from Excel is not holding?  TIA!
Peter Jamieson - 25 Apr 2006 13:33 GMT
Formatting (fonts, sizes etc.) are lost when you merge, regardless of the
connection type.

In this case you may be able to get around it by
a. cutting/pasting the sheet into a Word document (if there aren't too many
columns)
b. if the field in question is called xyz, instead of

{ MERGEFIELD xyz }

use

{ REF xyz } or just { xyz }

Longer term, it might be better to use the correct subscript in a Unicode
font that contains all the necessary characters - in that case, if you
connect using OLEDB and ensure that you use a suitable Unicdoe font in your
Word document as well, the subscript should get through.

Peter Jamieson

> User has Excel and Word 2002, SP-3
>
[quoted text clipped - 3 lines]
> checked and are using DDE to do the merge.  Any ideas why the formatting
> from Excel is not holding?  TIA!
Cindy M  -WordMVP- - 26 Apr 2006 08:44 GMT
Hi Peter/Brenda,

A small addition to Peter's posting. Sub- and Superscripts are NOT brought
across the mail merge interface, even when the data source is a Word table. The
only way to include them, short of the Unicode solution Peter suggests, is to
create them using EQ fields.

> Formatting (fonts, sizes etc.) are lost when you merge, regardless of the
> connection type.
[quoted text clipped - 15 lines]
> Word document as well, the subscript should get through.
>  

> > User has Excel and Word 2002, SP-3
> >
[quoted text clipped - 3 lines]
> > checked and are using DDE to do the merge.  Any ideas why the formatting
> > from Excel is not holding?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
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.