mail merge (more than 255 characters)

allenglishboy · #1 12-05-2011, 06:27 PM

I am trying to do a Mail Merge in WOrd 2003 from Excel file. Some of the fields are over 255 characters. I have read online that you can have fields larger than 255 charaters if you click tools> options> general and ensure that the "confirm conversion box" is checked.
I have tried to do this
When i click Open data source and browse to the file that I want to merge from I get a window that says Confirm Data Source and it has two options. The First option is OLE DB Database Files, If i click this option the merged document only has 255 characters.
If i click the second option, "Excel Files via ODBC", then i get the error message that "Word was unable to open the data source"
any help you could offer would be greatly appreciated, By the way, I am using word 2007.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge help	mike1982	Mail Merge	1	11-21-2011 02:56 AM
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM
Characters changing between software and mail merge output??	Calastein	Mail Merge	3	05-04-2011 01:50 AM
Junk characters (box-like characters) in Word file	Sashikala	Word	1	04-20-2010 02:03 PM
mail merge	Anthony	Outlook	1	09-29-2009 06:09 PM