View Single Post
 
Old 03-02-2017, 03:01 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Quote:
Originally Posted by Souriane View Post
This is because there is more than 255 characters in your field. When you use OLE DB connection to do you merging, you can't have more than 255 characters.
That's not correct.

When Word establishes the OLE DB connection, it tests the first ~8 records in each field to determine the data type. If those records contain text but none is more than 255 characters, Word treats it as a text field; if any of the records contains more than 255 characters, Word treats it as a memo field. Accordingly, all you need do in this case is ensure the first record, for example, contains more than 255 characters. You don't need to revert to the ancient DDE connection method.

This is all documented in the Mailmerge Tips & Tricks 'sticky' thread (https://www.msofficeforums.com/mail-...ps-tricks.html) at the top of this forum, under the heading Mailmerge Data Format Problems.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote