Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John Simmons John Simmons is offline
external usenet poster
 
Posts: 1
Default mail merge corrupts my data

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
  #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
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge corrupts tables Bill Mailmerge 1 September 19th 08 09:44 AM
How can I add data fields to a data source in Word Mail Merge? cd Mailmerge 2 November 7th 05 06:41 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
How do I move data Colums within the data source of a mail merge hf Microsoft Word Help 1 July 5th 05 09:57 PM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM


All times are GMT +1. The time now is 11:54 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"