View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge corrupts my data

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...-with-asp.aspx

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm