Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Mail merge two word Cruise Excel Worksheet Functions 4 October 15th 07 12:37 AM
mail merge from Excel to Word sumplug Excel Discussion (Misc queries) 2 August 17th 06 05:18 PM
making excel work like a mail merge tjb Excel Worksheet Functions 2 December 5th 05 11:11 PM
Merge mail excel to word T. Rebouche Excel Discussion (Misc queries) 2 February 22nd 05 12:05 AM
Word mail merge with Excel data Bailey Excel Worksheet Functions 2 January 30th 05 10:19 PM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"