View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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?