This should be easy, shouldn't it? (re: use of Excel file for mail from Word)

Factual Questions
1

I’m sure I’ve done this, or something like this before. But MS likes to change this stuff around every release or so, and it’s not something I do that often.

I have a data file in Excel 2002. I want to import it into MS Word 2002, and use the data in a mail merge to create a mailing labels. I don’t mind an intermediate step, such as first converting the Excel file into a Word table of some sort, if necessary. But the Help file for Word seems to indicate I should just be able to use the Excel file as a datafile. But I am drawing a blank on how to do this properly.

The alternative is type about 150 addresses into Excel. By now I should have probably just done that, but I’m obstinate sometimes.

A little help, please?

2

Of corse you can do it. On my version of Word, you just go to Tools - Letter and Mailings to start the Mail Merge wizard. Using Excel as a storage location for names and addresses is standard. Just follow the Wizard.

3

Right. You don’t need to convert it to Word, just point to the Excel file at the point where the directions tell you to. “Help” is your friend.

4

I think what happened was that I gave up on the Wizard too early, or used the wrong wizard. It got to a point where it looked wrong and I stopped there, but the address actually gets filled in later. So thanks to the goading of the two of you I have figured this out.