mail merge cut off or truncating 255 word limit

jim

unread,

Dec 18, 2008, 8:01:01 PM12/18/08

to

here is a good solution ms word 2003 (and probably works for other versions)
for mail merges using an excel database (just an excel spreadsheet with your
merge information)

in microsoft word 2003, with any document open, go to tools, options

click the general tab

check "confirm conversion at open"

exit microsoft word

restart microsoft word

connect your merge document to your database (excel spreadsheet/ms word
document with table)

when you do this, it will ask you to "Confirm Data Source"--choose MS Excel
Spreadsheets via DDE

it will now show all of the information in the spreadsheet.

why microsoft doesn't make this the default is beyond me. it has taken me 5
years to figure this out and i consider myself a pretty knowledgable user.

Peter Jamieson

unread,

Dec 19, 2008, 3:44:40 AM12/19/08

to

See http://tips.pjmsn.me.uk/t0003.htm for a more complete picture.

The DDE nethod works fine for a lot of people but does not cope with
everything.

What I would say is that the ODBC driver and OLE DB provider have always
needed fixing (and still need fixing) so that they behave consistently no
matter what data and formatting are in the sheet. Then we really could leave
the DDE method behind.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"jim" <j...@discussions.microsoft.com> wrote in message
news:CC50B663-9F97-474D...@microsoft.com...

Pete Russell

unread,

Jan 19, 2011, 11:16:05 AM1/19/11

to

Thank you very much JJ, I have been trying to solve this problem for years.

Your solution is superb - many, many thanks

>> On Friday, December 19, 2008 3:44 AM Peter Jamieson wrote:

>> See http://tips.pjmsn.me.uk/t0003.htm for a more complete picture.
>>
>> The DDE nethod works fine for a lot of people but does not cope with
>> everything.
>>
>> What I would say is that the ODBC driver and OLE DB provider have always
>> needed fixing (and still need fixing) so that they behave consistently no
>> matter what data and formatting are in the sheet. Then we really could leave
>> the DDE method behind.
>>
>> --
>> Peter Jamieson
>> http://tips.pjmsn.me.uk
>>
>> "jim" <j...@discussions.microsoft.com> wrote in message
>> news:CC50B663-9F97-474D...@microsoft.com...

>> Submitted via EggHeadCafe
>> WCF Generic DataContract object Serializer
>> http://www.eggheadcafe.com/tutorials/aspnet/59ae2b9e-a3be-4cd5-a0ef-939a7abbdc3a/wcf-generic-datacontract-object-serializer.aspx

PR

unread,

Jan 19, 2011, 11:18:15 AM1/19/11

to

Many thanks for posting this solution JJ, I have had trouble with this for years. Your solution is ideal

> On Thursday, December 18, 2008 8:01 PM ji wrote:

>> On Friday, December 19, 2008 3:44 AM Peter Jamieson wrote:

>> See http://tips.pjmsn.me.uk/t0003.htm for a more complete picture.
>>
>> The DDE nethod works fine for a lot of people but does not cope with
>> everything.
>>
>> What I would say is that the ODBC driver and OLE DB provider have always
>> needed fixing (and still need fixing) so that they behave consistently no
>> matter what data and formatting are in the sheet. Then we really could leave
>> the DDE method behind.
>>
>> --
>> Peter Jamieson
>> http://tips.pjmsn.me.uk
>>
>> "jim" <j...@discussions.microsoft.com> wrote in message
>> news:CC50B663-9F97-474D...@microsoft.com...

>>> On Wednesday, January 19, 2011 11:15 AM Pete Russell wrote:

>>> Thank you very much JJ, I have been trying to solve this problem for years.
>>>
>>>
>>>
>>> Your solution is superb - many, many thanks

>>> Submitted via EggHeadCafe
>>> SharePoint Tip / Thought of the Day WebPart
>>> http://www.eggheadcafe.com/tutorials/aspnet/14280ff8-3c9f-46bd-8214-9267e613c8ec/sharepoint-tip--thought-of-the-day-webpart.aspx