Mail Merge (Word) will not work with Excel selected files

[anne6marie]

I just upgraded from the old 2000 Office Professional to 2007 Office
Standard. The Mail Merge function will not work with my Excel files, in this
new version. Bad news, since it is one of the major functions I require, for
publishing mailing lists. It looks like this Christmas I'm going to be up
all night, handwriting about 150 envelopes, if I don't get some help soon, to
print mailing labels! I used "Select Recipients" on Word under "Mail Merge,
then click "Use Existing List". A dialog box appears, "Select Data Source",
in which Excel files are not listed! Any ideas?

 

[Roger Govier]

Hi Anne Marie

Yes, it does look a bit daunting, doesn't it!!!
But you can use Excel Files.

In Word, Mailings Tab>Select Recipients>Use Existing List>Navigate to the
Folder containing your Excel file>
If required, use dropdown at bottom right of dialogue "All Data Sources" to
select Excel files (10th item in list)

Then only the Excel files in your selected folder will be visible>Click on
file requires and proceed just as in previous versions.