Reply
 
Thread Tools Display Modes
  #1   Report Post  
martinenatasha
 
Posts: n/a
Default How do I mail merge fields exceeding 255 characters from Excel to.

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?
  #2   Report Post  
JodiMac
 
Posts: n/a
Default

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

"martinenatasha" wrote:

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Difficulties mail merging special characters from excel to word 20 Nondejuu Mailmerge 1 January 5th 05 01:30 PM
International characters in mail merge sandra Mailmerge 1 December 23rd 04 05:42 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM


All times are GMT +1. The time now is 03:17 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"