Mail Merge with Excel and Word 2007

  • Thread starter Thread starter nodeerhere
  • Start date Start date
N

nodeerhere

I know that Excel does not handle fields that are longer than 255 characters. In my merge, the info in the long field is truncated. I thought this wasfixed in 2007. Apparently not. The only fix I've found is to add a dummy record at the top of the Excel file and put a very long string of text in that field.

Can anyone suggest a better fix? I am not doing any programming here. Just using the data in the Excel file to generate a report.
 
I know that Excel does not handle fields that are longer than 255
characters.
Click to expand...


This depends on what you're doing. For example, you can't copy/paste or
move/copy sheets with more than 256 characters without the text being
truncated. Otherwise, you can transfer the text via VBA no problem, and
most other tasks work fine.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

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

Help merging worksheets with more than 255 characters... 5
form/mail merge in Excel w/out using Word 1
mail merge problem 4
Excel Problems merging Excel data into Word – cutting off at 255 characters 0
Wrong date format in mail merge 2
VBA: 2007 ==> 2010, How Badly Broken? 7
Open a word mail-merge document from Excel VBA 1
Mailing labels using only Excel? 4

Back
Top