Mail merge - multiple fields combining into one merge field.

[Alex Lush]

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.

 

[Peter Jamieson]

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