mail merge corrupts my data

John Simmons · External Since: Nov 06, 2009 Posts: 1

I am using a large excel spreadsheet with several data fields, with which I am using mail merge to tabulate forms in word. All of the cells in Excel are formatted as text. When doing the merge, it generally works, except fields with a long string of numbers gets corrupted by extraneous numbers and garbage characters. Why is this happening and what can I do to prevent it. This is on Word/Excell 2003. The company will not be upgrading for quite some time.

EggHeadCafe - Software Developer Portal of Choice
Getting Started With ASP.NET
http://www.eggheadcafe.com/tutorials/aspnet/21809063-0a09-4c56-99e5-09...08f1317

Doug Robbins - Word MVP · External Since: Nov 07, 2009 Posts: 3

John Simmons wrote:
> I am using a large excel spreadsheet with several data fields, with which I am using mail merge to tabulate forms in word. All of the cells in Excel are formatted as text. When doing the merge, it generally works, except fields with a long string of numbers gets corrupted by extraneous numbers and garbage characters. Why is this happening and what can I do to prevent it. This is on Word/Excell 2003. The company will not be upgrading for quite some time.
>
>
> EggHeadCafe - Software Developer Portal of Choice
> Getting Started With ASP.NET
> http://www.eggheadcafe.com/tutorials/aspnet/21809063-0a09-4c56-99e5-09...08f1317
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm