Table Look-up in WORD mailmerge

[SmithBurn]

In running a mailmerge from WORD using an EXCEL worksheet list, is there a function I can use to have a short code in the EXCEL list expanded to a full title name using a separate two-column range on the EXCEL worksheet?

 

[Graham Mayor]

Can you give an example of what you are trying to do?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?U21pdGhCdXJuQEFPTC5jb20=?=,

In running a mailmerge from WORD using an EXCEL worksheet list, is there a function I can

use to have a short code in the EXCEL list expanded to a full title name using a separate
two-column range on the EXCEL worksheet?In essence, no. But why not add a column to the Excel sheet providing the data source that
doesn this?

The only other possibility would be to use MS Query to link the two spreadsheet tables.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail