Mail Merge Issue

G

George Wilson

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
 
G

Graham Mayor

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Top