Re: Cell >255 Character - Error Mail merge to MS word.
- From: Randoo <Randoo@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 8 Jan 2007 02:43:00 -0800
Nick,
Thanks for your prompt response mate.
I have tried the suggestion you have given but the situation did not
change....
1) After checking "Confirm Conversation at Open", there was no prompt
different data type as you mentioned.... The only prompt that prop. up when
i open the MS word doc. was checking to see if i would like to run the SQL
command & open a particular field...
2) removing the Headers/Footer does not work my PC....
Help~~ Plz~~
Thank you in advance.
Randoo
"Nick Hodge" wrote:
Randoo.
There are some real issues with this particularly in Excel/Word before and
including 2000.
It seems one of the following should work
1) In WORD go to Tools>Options...>General and check confirm conversion at
open. This will prompt you for Data Type to use, ODBC, OLEDB, DDE, etc.
Select DDE and see if that works
2) Delete the headers in the Excel File. (Makes it a little more difficult
to manage in Word but...
Seems this is something the Excel and Word teams have not successfully fixed
since Excel had a 255 character limit in a cell ;-)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxx
www.nickhodge.co.uk
"Randoo" <Randoo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0E516272-CCFC-4F7E-8440-EF9932C56EC3@xxxxxxxxxxxxxxxx
Greetings,
I am having difficulties with extracting data from an excel cell with data
255 char. in length when i use the mailmerge function.... The info. in MSword is truncated to 255 in length... please help!!
I am kind of newbee for with database with large amount of info..... I
have
spent >100hours in collection info. and designing the current database.
Be
good if someone can give me suggestion.
I have little knowledge in VBA also (i might need to learn about it
however
if that's the only quick fix to the problem.
Thank you in advance :)
Randoo
- Follow-Ups:
- Re: Cell >255 Character - Error Mail merge to MS word.
- From: Nick Hodge
- Re: Cell >255 Character - Error Mail merge to MS word.
- References:
- Re: Cell >255 Character - Error Mail merge to MS word.
- From: Nick Hodge
- Re: Cell >255 Character - Error Mail merge to MS word.
- Prev by Date: Re: What is wrong in formula.
- Next by Date: Re: advance lookup and paste
- Previous by thread: Re: Cell >255 Character - Error Mail merge to MS word.
- Next by thread: Re: Cell >255 Character - Error Mail merge to MS word.
- Index(es):
Relevant Pages
|
