Using named ranges in mail merge documents?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole - 09 Mar 2004 22:37 GMT

Hello, everyone. Is there any way of using named ranges (in Excel) as
the merge fields in a (Word) data merge document? I mistakenly
formatted my data source with the field labels at left and the records
at top (in other words, with the whole table rotated 90 degrees), and
I've been trying to figure out a way to get the proper fields into the
data merge document. Alternately, a way of rotating the table in Excel
would work. (There's too much data to cut and paste into a new
format.) Any advanced users here who can help with this?

Thanks,
Nicole

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 10 Mar 2004 02:31 GMT

In Excel, copy the information, then go to a new Excel sheet and from the
Edit menu, select Paste Special and check the Transpose box. That will
transpose the rows and columns so that the field labels should be in the
place expected for the merge operation.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hello, everyone. Is there any way of using named ranges (in Excel) as
> the merge fields in a (Word) data merge document? I mistakenly
[quoted text clipped - 7 lines]
> Thanks,
> Nicole

Reply to this Message