Thread: [Solved] Mail Merge: cannot display the field in Excel correctly
View Single Post
 
Old 08-16-2012, 12:05 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
As I said:
Quote:
Where you have numerous empty cells or mixed numbers and text in the first 16 rows in a column, you are liable to have 0s instead of the text in the mailmerge output.
If you want to know the gory details, see 'How the OLE DB determines the data type for a column' at: http://tips.pjmsn.me.uk/t0003.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote