Mail merge - multiple fields combining into one merge field.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Lush - 12 Nov 2003 09:46 GMT

I have a mail merge set up to pull data from excel into
word.

One of the fields appears to be pulling out the correct
data from excel then adding the remainder of the row from
the excel sheet within the same merge field (the output is
seperated by tabs).

Its as though it hasn't realised that its reached the end
of the cell on the worksheet and just carried on.

This only happens on certain records and only in one merge
field.

I'm using word 97 and excel 97 on win98.

(files available for emailing if easier)

Thanks.

Reply to this Message

Peter Jamieson - 12 Nov 2003 11:05 GMT

OK, I just replied in the other thread where you were asking about this.

My guess is that you have double-quote characters in your data.

If so, possible workarounds include:
a. Use the "in" abbreviation for inches instead of "
b. Go through the data source connection process again, and check "Select
method" in the Open Data Source dialog. When asked, choose the converter
option. (You are probably currently using the DDE option, and in this case
my guess is that if you try the ODBC option, the data will be blank for the
height field).

--
Peter Jamieson
MS Word MVP

> I have a mail merge set up to pull data from excel into
> word.
[quoted text clipped - 15 lines]
>
> Thanks.

Reply to this Message