Solved

Truncated text from Excel to Word Merge

Posted on 2007-04-03
7
304 Views
Last Modified: 2012-05-05
Hi All

I am merging to word from excel (2003)

The fields are being truncated after 255 characters.

Why? And is there a solution.

0
Comment
Question by:danhleighton
  • 3
  • 2
  • 2
7 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18842484
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
 
LVL 45

Accepted Solution

by:
patrickab earned 500 total points
ID: 18842494
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
 

Author Comment

by:danhleighton
ID: 18842612
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18842630
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
 
LVL 45

Expert Comment

by:patrickab
ID: 18842845
>I understand but I am not sure whether that is going to work!

Why wouldn't it work?
0
 

Author Comment

by:danhleighton
ID: 18937947
Thanks all PatrickAB has provided the answer which helped me.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 18942034
danhleighton - Thanks for the points - Patrick
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now