Mail Merge Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George Wilson - 16 Sep 2004 18:17 GMT

I am currently using Office XP on a Windows XP system. I
am creating a mail merge from an existing Excel document.
I have an older version of this merge already created and
it pulls the data just fine from the source Excel
document. The new merge document I am creating is
stripping the commas from numeric monetary fields, date
fields are not showing properly, date field entries with
no entry are showing up as a time. Is there a setting in
word that causes this to happen? The Excel document seems
fine and all the info pulls correctly from this sheet to
another merge document so the setting has to be within the
document. Any Ideas?
TIA
George

Reply to this Message

Graham Mayor - 16 Sep 2004 18:38 GMT

Current versions of Word use a different method of connecting to data for
the purpose of merge and now Word is required to provide the formatting -
you should be able to work out what you need to add from
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am currently using Office XP on a Windows XP system. I
> am creating a mail merge from an existing Excel document.
[quoted text clipped - 10 lines]
> TIA
> George

Reply to this Message