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.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Deanna wrote:
Using 2003; have a spreadsheet I have used in a Word mail merge. One
column of the xls file is for the grade of school student is in (1,
2, 3, 4, K, P1, P2). When viewing the xls file in Word, the column
is showing the 1, 2, 3, and 4 but is putting 0 for the K, P1 and P2.
I've tried changing the xls file formating on the column to General
and Text but nothing seems to help.