[olrustyxlsuser]

Hello,
Office 2007 (Enterprise) - Doing a mail merge where data from the data
source is changed from fraction to decimal in the merge. How can I change
the data back to fraction? Pretty sure I'll have to use a switch, but can't
find the correct format.
TIA.
John

[Graham Mayor]

From the Office button in Word, select Word Options and then go to the
Advanced tab General and check the box against the "Confirm conversions
at open" item. 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 Excel table.

Fields I'm afraid don't do fractions -
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



olrustyxlsuser wrote:
Hello,
Office 2007 (Enterprise) - Doing a mail merge where data from the data
source is changed from fraction to decimal in the merge. How can I
change the data back to fraction? Pretty sure I'll have to use a
switch, but can't find the correct format.
TIA.
John

[olrustyxlsuser]

Thank you Graham. This works splendidly! I had problems connecting via DDE
a couple of times, but was able to fix the problem by slightly changing the
layout of the source file, ie. deleting empty rows, etc.
Much appreciated.
John

"Graham Mayor" wrote:

From the Office button in Word, select Word Options and then go to the
Advanced tab General and check the box against the "Confirm conversions
at open" item. 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 Excel table.

Fields I'm afraid don't do fractions -
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



olrustyxlsuser wrote:
Hello,
Office 2007 (Enterprise) - Doing a mail merge where data from the data
source is changed from fraction to decimal in the merge. How can I
change the data back to fraction? Pretty sure I'll have to use a
switch, but can't find the correct format.
TIA.
John

[Graham Mayor]

DDE is a bit flaky which is why it is no longer the default, but it is the
only way to bring in formatting that cannot be recreated in Word.

--

Graham Mayor - Word MVP

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


olrustyxlsuser wrote:
Thank you Graham. This works splendidly! I had problems connecting
via DDE a couple of times, but was able to fix the problem by
slightly changing the layout of the source file, ie. deleting empty
rows, etc.
Much appreciated.
John

"Graham Mayor" wrote:

From the Office button in Word, select Word Options and then go to
the Advanced tab General and check the box against the "Confirm
conversions at open" item. 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 Excel table.

Fields I'm afraid don't do fractions -
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



olrustyxlsuser wrote:
Hello,
Office 2007 (Enterprise) - Doing a mail merge where data from the
data source is changed from fraction to decimal in the merge. How
can I change the data back to fraction? Pretty sure I'll have to
use a switch, but can't find the correct format.
TIA.
John