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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

martinenatasha - 20 Jan 2005 19:25 GMT

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?

Reply to this Message

JodiMac - 27 Jan 2005 16:17 GMT

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

> I am using the mail merge function to merge a large amount of data from an
> Excel 2003 spreadsheet into a Word 2003 document.
[quoted text clipped - 3 lines]
>
> How can I work around this problem? Perhaps it can be done through macros?

Reply to this Message