View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail merge data not showing on Mail Recipient List

OK, can't look right now, but are the vlookup columns that fail returning
long texts (probably longer than around 255 characters?) or mixed field
types (some text, some numeric). If so, how about the vlookups that succeed?


Peter Jamieson

"Connie G" wrote in message
...
Hi Peter,
From Word merge doc, I open the Mail Recipient List and all the column
headers show (there's about 20 columns), but data for columns B & C only
is
missing - there is a thick (:) black line followed by dots where data
should
be.

As a test, I copied and did a paste special into a blank spreadsheet, and
the merge works fine if there are no formulas; however, I'd prefer to fix
the
problem and avoid this extra step, since there are already several steps
before getting to the merge itself. Columns B&C contain a VLookup
formula,
but several other columns do as well, and they show up OK.

Thank you for your help in investigating this problem.
Connie G.

"Peter Jamieson" wrote:

The list has think black lines instead of the
data. How can I fix this problem?


Which version of Word/Excel?

Do you see the column headings in the Mail Recipients dialog?

What do the black lines look like? Do they run from side to side in each
cell, or do you mean that the vertical lines between the columns of data
are
thicker than usual (not sure whether you meant "thin" or "thick" when you
said "think" :-) But in either case I haven't seen this before so am just
looking for clues).

What kind of data do you have in the affected columns? (or perhaps, the
ones
before)?

As an immediate workaround, if you are using Word XP or 2003, check
Word|Tools|Options|General|"Confirm conversions at open", then reconnect
to
your data source and choose the DDE option when it is offered. It may not
make any difference but it is worth a try.

Peter Jamieson
"Connie G" Connie wrote in message
...
I am trying to create a mail merge from Excel spreadsheet, and Mail
recipient
list does not show data from several columns in mail recipient list,
even
though the data is there. The list has think black lines instead of
the
data. How can I fix this problem?

Thanks so much for your help,
Connie G