Mailmerge with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carrie - 06 Nov 2006 14:25 GMT

I have Word and Excel 2003. When I merge a document in Word with an excel
spreadsheet, not all of the data comes back into Word, which means that I end
up cutting and pasting information, where mailmerge should have done it all
in one move. What am I doing wrong?

Reply to this Message

Graham Mayor - 06 Nov 2006 15:14 GMT

What sort of information is missing?

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have Word and Excel 2003. When I merge a document in Word with an
> excel spreadsheet, not all of the data comes back into Word, which
> means that I end up cutting and pasting information, where mailmerge
> should have done it all in one move. What am I doing wrong?

Reply to this Message

carrie - 06 Nov 2006 15:26 GMT

The data in the Excel spreadsheet is text comments from a variety of surveys.
Some of the fields come through into Word with only part of the text that
has been entered (ie it ends part way through the sentence). There is no
pattern to this (ie it's not just the cells with a lot of text, it can also
be cells with only a few sentences).

> What sort of information is missing?
>
> > I have Word and Excel 2003. When I merge a document in Word with an
> > excel spreadsheet, not all of the data comes back into Word, which
> > means that I end up cutting and pasting information, where mailmerge
> > should have done it all in one move. What am I doing wrong?

Reply to this Message

Graham Mayor - 06 Nov 2006 15:35 GMT

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. 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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> The data in the Excel spreadsheet is text comments from a variety of
> surveys. Some of the fields come through into Word with only part of
[quoted text clipped - 16 lines]
>>> means that I end up cutting and pasting information, where mailmerge
>>> should have done it all in one move. What am I doing wrong?

Reply to this Message