Truncated text from Excel to Word Merge

Hi All

I am merging to word from excel (2003)

The fields are being truncated after 255 characters.

Why? And is there a solution.

danhleightonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
It is, as far as I know, a limitation of all versions of Office other than 2007. To workaround it, I think you would need to use automation to open the Excel workbook and populate bookmarks in the Word document.
Regards,
Rory
0
patrickabCommented:
I suggest that you split the Excel strings into 225-long chunks in differents Excel cells, give them a <<fieldname>> and add them into the Word merge.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
danhleightonAuthor Commented:
Thanks guys

Rorya I don't really understand what you mean there...

Patrick  - I understand but I am not sure whether that is going to work!

Can I create an Access DB using the spreadsheet as the source and then create a series of lookup tables with all the fields set to memo?


0
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Rory ArchibaldCommented:
You can link a worksheet as a table in an Access db.
By automation, I mean that you would write code to physically start an instance of Excel, open the workbook you want and then loop through all the rows, populating and printing the word document as necessary. The Access db may be an easier option!
Regards,
Rory
0
patrickabCommented:
>I understand but I am not sure whether that is going to work!

Why wouldn't it work?
0
danhleightonAuthor Commented:
Thanks all PatrickAB has provided the answer which helped me.
0
patrickabCommented:
danhleighton - Thanks for the points - Patrick
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.