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 / December 2006

Tip: Looking for answers? Try searching our database.

Getting 0's when merging

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
thandy - 19 Dec 2006 12:40 GMT
I'm trying to merge addresses from excel to word and although all the columns
are labelled, the information in two of them comes up as '0's and not the
information that is contained.  No idea why its doing this as I have used
simular formatting for merging before and it was fine.  Can anyone help?
Peter Jamieson - 19 Dec 2006 13:13 GMT
Check Word Tools|Options|General|"COnfirm conversion at open", reconnect to
your data source, and choose the DDE option when it is offered.

This occurs because when the data types in an Excel column are mixed (e.g.
some things look like numbers and some things look like text), the OLEDB
provider that Word uses to get the data makes a choice based on which data
type predominates in the first 25 rows of the column. So even if it worked
before, changes to the data can change the behaviour. There are one or two
other approaches that may help, but the DDE one is generally the best
starting point.

Peter Jamieson

> I'm trying to merge addresses from excel to word and although all the
> columns
> are labelled, the information in two of them comes up as '0's and not the
> information that is contained.  No idea why its doing this as I have used
> simular formatting for merging before and it was fine.  Can anyone help?
 
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.