Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2008

Tip: Looking for answers? Try searching our database.

Error in mail merger: contained too many data fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Inger - 11 Mar 2008 09:49 GMT
the data source is an excel document, what can the reason be for this error
message, and do anybody know a solution?
Graham Mayor - 11 Mar 2008 09:56 GMT
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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> the data source is an excel document, what can the reason be for this
> error message, and do anybody know a solution?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.