Re: Font Change

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Do you have the box against "Confirm conversions at open" checked in Office
Button > Word Options > Advanced > General? Did you re-attach the data
source to the main document? If you did, did a dialog box open asking you
for the method by which the connection should be made? If it did, did you
click on the "Show all connections" button? That may be required to expose
the DDE connection method.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Michael Koerner" <iamnot@xxxxxxxx> wrote in message
news:Ohml860mIHA.5260@xxxxxxxxxxxxxxxxxxxxxxx
Graham;

Tried your suggestion, didn't work for me. I didn't receive any options to
use DDE. Is this because I'm using a Word template that I created back in
2003?

--

Regards
Michael Koerner


"Graham Mayor" <gmayor@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23Vnj1axmIHA.5208@xxxxxxxxxxxxxxxxxxxxxxx
The default merge will only merge the raw data. You can format the field and
add a charformat switch to ensure that the formatting sticks, but if your
italics are only in part of the field this won't help much. In that case,
from the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button > Word Options > Advanced > General > Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.
However DDE connection can be quite flaky.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

"Michael Koerner" <iamnot@xxxxxxxx> wrote in message
news:%23qsuiFxmIHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
Using Office 2007, when I do a mail merge using Excel as the data source.
The items I have in italics in Excel are removed once the merge is complete
in Word. Is there as setting I can use to ensure that font formatting is
retained? Or, maybe a macro that I can run after the merge is complete to
change everything in () to italics including the ()

--

Regards
Michael Koerner


.



Relevant Pages

  • Re: Merge fields
    ... This is caused by a bug in the default OLEDB method of connection to the ... Format the dates as text in Excel ... when you attach the data source to the mail ... in the dialog that opens asking you for the method by ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge fields
    ... connection is that I have to tick the 'show all' option in the Confirm Data ... Source diaglogue box and then untick it before clicking on DDE. ... Format the dates as text in Excel ... when you attach the data source to the mail ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Ada DB bindings and APQ
    ... but otherwise how the connection is made is ... there are interface and implementation objects. ... > are suggesting is that I should not have a Map object, ... It is a myth caused by automatic conversions of PL/1 and C. ...
    (comp.lang.ada)
  • Re: formatting dates in queries
    ... class and can't be called directly without using reflection. ... to get the appropriate factory object for creating a specific connection ... Anyone have any good guidance on how to decide at runtime which format ... vendor writes a NET 2.0 data provider that I don't have), ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: formatting dates in queries
    ... System.Reflection.BindingFlags.NonPublic, null, _builder, new object{ ... to get the appropriate factory object for creating a specific connection ... Anyone have any good guidance on how to decide at runtime which format to ... vendor writes a NET 2.0 data provider that I don't have), ...
    (microsoft.public.dotnet.framework.adonet)