Excel _> Word

[dave munday]

trying to merge from Excel to Word, excel field is > 256
chars ... word only displays first 255

is there a work around

many thanks for your time

Dave

 

[Cindy M -WordMVP-]

Hi Dave,

Version of Word, please?

trying to merge from Excel to Word, excel field is > 256
chars ... word only displays first 255

is there a work around

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Dave Munday]

Cindy

many thanks for your reply,

word and Excel XP-SP2

Dave

 

[Cindy M -WordMVP-]

Hi Dave,

OK, I've tested in Word 2002, original release (no SPs) using
all four available connection methods and it always brought
across > 255 characters where so many were in the field (I
tested with 300).

Which connection method are you using? Do you get all the
characters if you use a different one? (If you don't know how
to specify the connection method, check in the Word2002 section
of my website's mail merge FAQ, where it talks about using the
connection methods from earlier versions)

word and Excel XP-SP2

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30
2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Dave Munday]

Cindy
apologies for the delay, I have been off-site and will look at your response
this evening

Many thanks

Dave