How do I mail merge fields exceeding 255 characters from Excel to.

M

martinenatasha

I am using the mail merge function to merge a large amount of data from an
Excel 2003 spreadsheet into a Word 2003 document.

It appears as though any Excel field which exceeds 255 characters gets cut
off at exactly the 255 character limit mark in the merging process.

How can I work around this problem? Perhaps it can be done through macros?
 
J

JodiMac

I am doing the same thing and have encountered this problem. I find that when
my input (Excel) file does not contain headers, the merge works just
fine....fields of more than 255 characters display correctly. As soon as I
add a header row to the input file, fields longer than 255 characters are
truncated. It sure would be nice to be able to use the column headers in the
mail merge template (as they are descriptive and multiple people will be
using the template).

Have you learned anything else since you posted this question?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mail merge (word 2010) cuts off the text after 255 characters 1
Help merging worksheets with more than 255 characters... 5
255 limit on Mail Merge Fields? 2
Will Word mailmerge more than 255 characters from an Excel file? 4
SQLStatement exceed 255 characters in word mail merge using ms accessdatabase 4
SOLVED: Skipped records in Word Mailmerge from Excel data source 0
How do I overcome character limits in a mail merge from excel? 1
How do I get more than 255 characters into a cell? 3

Top