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

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?

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

Hi Anne Marie

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

In Word, Mailings TabSelect RecipientsUse Existing ListNavigate 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 visibleClick on
file requires and proceed just as in previous versions.
--

Regards
Roger Govier

"anne6marie" wrote in message
...
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?