Excel Data Missing in Word's Mail Merge handler

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Siano - 08 Nov 2004 20:14 GMT

I have a spreadsheet with a region used for a mail merge. One column contains
text strings. But, when I use Word to set up a merge form, and select the
sheet's data for merging, this one column is treated as though it were blank.
Instead of the spreadsheet's text strings, I get "0."

This happens in the Merge dialogue box, where I can sort and filter the data.

The column draws from other cells, is formatted as text in Excel, and is the
only column giving me this problem.

Reply to this Message

Rudy Frappier - 09 Nov 2004 19:03 GMT

Brian ... I'm having the same problem!! I'm new to newsgroups, and haven't
found the replies ... is there any chance you could send me the information
if you find it???

> I have a spreadsheet with a region used for a mail merge. One column contains
> text strings. But, when I use Word to set up a merge form, and select the
[quoted text clipped - 5 lines]
> The column draws from other cells, is formatted as text in Excel, and is the
> only column giving me this problem.

Reply to this Message

Rudy Frappier - 09 Nov 2004 19:04 GMT

Brian .. I'm having the same problem! I'm new to newsgroups and haven't
found the replies section!! Is there any chance you can forward the answer
to me when you get it?

Thanks.

Reply to this Message