Thread: [Solved] Problems With Office Pro 2010
View Single Post
 
Old 10-10-2011, 02:52 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi timbo,

Part of the problem may have to do with the way Word determines whether a particular source field (ie Excel column) contains numbers or alpha-numeric strings. If the first few records (Excel rows) contain numbers (or are, perhaps, empty), the whole field (column) may be treated as numeric. In that case records containing anything other than numbers may be missed or evaluated as 0.

Alternatively, the problem may be to do with how your data are defined. If some records are being output correctly and others aren't, that's an area I'd be looking at. For example, are you sure the data have all be input & formatted the same way? Look carefully for the differences between the records that do export correctly and those that don't. Note too that things like double quotes in a record can seriouly mess up that record's mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote