Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Inger Inger is offline
external usenet poster
 
Posts: 1
Default Error in mail merger: contained too many data fields

the data source is an excel document, what can the reason be for this error
message, and do anybody know a solution?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Error in mail merger: contained too many data fields

You probably have a record that has a separator character eg a comma, that
Word treats as the end of the field thus breaking the field into two
'fields' hence the error message.See if the following helps:

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.

Otherwise edit your data source to correct the problem.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Inger wrote:
the data source is an excel document, what can the reason be for this
error message, and do anybody know a solution?



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
Record 16 contained to few data fields Ben Mailmerge 1 March 23rd 06 11:21 AM
record 16 contained too few data fields error on word 2003 from cs Deanjr Mailmerge 3 March 6th 06 03:10 PM
Record 1 contained too few data fields HJ Mailmerge 1 May 20th 05 02:10 PM
Repost: Record 1 contained too few data fields HJ Mailmerge 0 May 16th 05 04:11 PM
Record 1 contained too few data fields ladyfiona New Users 0 March 17th 05 03:22 AM


All times are GMT +1. The time now is 08:19 AM.

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"