Merging fields with more than 256 characters

R

Rhapsody

When merging fields from Excel to Word in Office 2003 I have
encounterd this strange problem that if a field contains more than 256
characters, Word does import only those 256 first characters in the
cell, but not the rest...

Is there someone who kows how I can get this to work with long fields?

Kind regards,
Lieven
 
G

Graham Mayor

Fellow Word MVP Peter Jamieson was the expert on data connection and had
some information on his web site, but he has withdrawn from regular use of
the forums and his site appears to be down. However checking his posts at
Google, it seems that the problem is associated with the way Word connects
to its data. See if the following helps:

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button > Word Options > Advanced > General > Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Top