Mail merge field isn't displaying all the text in a field. Can I .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mojohubbard - 26 Mar 2005 05:13 GMT

I'm trying to make bid sheets for a silent auction. I'm merging data from my
donation Excel Spreadsheet. One of the fields is a description of the auction
item. It's fairly long (also being merged into Publisher for the catalog) and
when I merge it into Word the Mail Merge Recipients List window shows all the
text, but when I merge it into the document, it cuts me off at 255
characters. Is there any way I can extend this? If I have to manually update
every bid sheet I'm kinda defeating the purpose. Thanks for any insight.

Reply to this Message

Cindy M -WordMVP- - 26 Mar 2005 12:20 GMT

Hi =?Utf-8?B?bW9qb2h1YmJhcmQ=?=,

> I'm trying to make bid sheets for a silent auction. I'm merging data from my
> donation Excel Spreadsheet. One of the fields is a description of the auction
[quoted text clipped - 3 lines]
> characters. Is there any way I can extend this? If I have to manually update
> every bid sheet I'm kinda defeating the purpose.

Which version of Word are we dealing with, here?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

Reply to this Message

mojohubbard - 26 Mar 2005 21:19 GMT

Word 2003

> Hi =?Utf-8?B?bW9qb2h1YmJhcmQ=?=,
>
[quoted text clipped - 15 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 28 Mar 2005 16:45 GMT

Hi =?Utf-8?B?bW9qb2h1YmJhcmQ=?=,

OK, then it's probably linking using the default, OLEDB connection. Let's see if
using a different connection method helps. Activate the Confirm Conversions on Open
setting in Tools/OPtions/General. Now select the data source file and you should get
a list of connection methods. Try DDE, for starters. Note that the worksheet with
the data should be the first sheet in the workbook in order for this to work.

> Word 2003
> >
[quoted text clipped - 5 lines]
> > > characters. Is there any way I can extend this? If I have to manually update
> > > every bid sheet I'm kinda defeating the purpose.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

Reply to this Message