Mail Merge 2003 formating RPS 5/30/2007 7:45:01 PM When merging an Excel spreadsheet to a word document there are columns that replace the Alpha letter of K to a zero. The first column works but 2 others do not? Numbers work in these columns but the Alpha letters do not? Format is set to general just as it is in the first column. If I place an additional line at the top of the Excel sheet and put a Alpha Letter in the first line then it reads the other numbers and letters farther down in the columns? Any suggestions as to why this is happening?

Re: Mail Merge 2003 formating "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/31/2007 3:28:41 AM With some methods of connection to the data source, mailmerge uses the data in the first record to determine the type of data. If the formatting of the column is set to Text, then it will probably work OK. Or in Word, from the Tools menu, select Options and then on the General tab, check the box against Confirm conversions at open and then when you attach the Excel spread sheet as the data source, select the DDE option. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "RPS" <RPS[ at ]discussions.microsoft.com> wrote in message news:5402C6FB-4FAF-4471-B738-D889B5F2F3D2[ at ]microsoft.com... [Quoted Text] > When merging an Excel spreadsheet to a word document there are columns > that > replace the Alpha letter of K to a zero. The first column works but 2 > others > do not? Numbers work in these columns but the Alpha letters do not? > Format > is set to general just as it is in the first column. > If I place an additional line at the top of the Excel sheet and put a > Alpha > Letter in the first line then it reads the other numbers and letters > farther > down in the columns? > Any suggestions as to why this is happening?

Re: Mail Merge 2003 formating "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/2/2007 8:03:10 AM There's a lengthy "explanation" of this problem at http://tips.pjmsn.me.uk/t0003.htm but the solution Doug provided is probably the simplest. Peter Jamieson "RPS" <RPS[ at ]discussions.microsoft.com> wrote in message news:5402C6FB-4FAF-4471-B738-D889B5F2F3D2[ at ]microsoft.com... [Quoted Text] > When merging an Excel spreadsheet to a word document there are columns > that > replace the Alpha letter of K to a zero. The first column works but 2 > others > do not? Numbers work in these columns but the Alpha letters do not? > Format > is set to general just as it is in the first column. > If I place an additional line at the top of the Excel sheet and put a > Alpha > Letter in the first line then it reads the other numbers and letters > farther > down in the columns? > Any suggestions as to why this is happening?