Mail merge data not showing on Mail Recipient List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Connie G - 24 Oct 2006 21:01 GMT

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

Reply to this Message

Peter Jamieson - 25 Oct 2006 12:31 GMT

> 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

>I am trying to create a mail merge from Excel spreadsheet, and Mail
>recipient
[quoted text clipped - 4 lines]
> Thanks so much for your help,
> Connie G

Reply to this Message

Connie G - 25 Oct 2006 20:16 GMT

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.

> > The list has think black lines instead of the
> > data. How can I fix this problem?
[quoted text clipped - 26 lines]
> > Thanks so much for your help,
> > Connie G

Reply to this Message

Peter Jamieson - 26 Oct 2006 00:08 GMT

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

> Hi Peter,
> From Word merge doc, I open the Mail Recipient List and all the column
[quoted text clipped - 50 lines]
>> > Thanks so much for your help,
>> > Connie G

Reply to this Message

Connie G - 26 Oct 2006 14:28 GMT

Hi Peter - The problem columns, B and C, return names; the other vlookup
columns return numbers.
Thanks,
Connie

> 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
[quoted text clipped - 56 lines]
> >> > Thanks so much for your help,
> >> > Connie G

Reply to this Message

Peter Jamieson - 26 Oct 2006 16:17 GMT

Hi Connie,

OK, so far I have been unable to make my VLOOKUPS fail, but my sample data
may be too simple. The info. that it is apparently only the text fields that
fail may well be significant but so far there is no difference here.

If you can replicate the problem using test data that you feel able to send
me, you are welcome to de-SPAM my e-mail address (remove "KillmapS") and
e-mail me your xls file(s) and a mail merge main document, and I will have a
look. Please let me know which version of Word/Excel you are using.

Peter Jamieson
pjj@KillmapSpjjnet.demon.co.uk

> Hi Peter - The problem columns, B and C, return names; the other vlookup
> columns return numbers.
[quoted text clipped - 73 lines]
>> >> > Thanks so much for your help,
>> >> > Connie G

Reply to this Message

Connie G - 25 Oct 2006 20:21 GMT

P.S. I'm working in Word/Excel 2003 with Windows XP Professional. Thanks

> > The list has think black lines instead of the
> > data. How can I fix this problem?
[quoted text clipped - 26 lines]
> > Thanks so much for your help,
> > Connie G

Reply to this Message