How to show date / currency format in mailmerge from Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LoreKai - 14 Oct 2007 11:51 GMT

My database is in Excel and I have dates, percentages and currency
auto-formated in there. When I use mailmerge Word 2007 ignores all that
formating making my documets a mess. If I use Word 97 it keeps all the
formatting intact but that then stops Word 2007 from working. If anyone can
tell me how to make Word 2007 show the correctly formatted data I will be so
happy! :)

Reply to this Message

Graham Mayor - 14 Oct 2007 12:11 GMT

Microsoft has changed the way merges connect to the data from the flaky DDE
method (it actually changed in version 2002). You could still adopt DDE -
From the Word Options > Advanced 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 table.

Or easier still, use formatting switches on your merge fields -
http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> My database is in Excel and I have dates, percentages and currency
> auto-formated in there. When I use mailmerge Word 2007 ignores all
> that formating making my documets a mess. If I use Word 97 it keeps
> all the formatting intact but that then stops Word 2007 from working.
> If anyone can tell me how to make Word 2007 show the correctly
> formatted data I will be so happy! :)

Reply to this Message

LoreKai - 16 Oct 2007 14:22 GMT

Thanks a lot Graham! :)

> Microsoft has changed the way merges connect to the data from the flaky DDE
> method (it actually changed in version 2002). You could still adopt DDE -
[quoted text clipped - 12 lines]
> > If anyone can tell me how to make Word 2007 show the correctly
> > formatted data I will be so happy! :)

Reply to this Message