Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Mail merge two word | Excel Worksheet Functions | |||
mail merge from Excel to Word | Excel Discussion (Misc queries) | |||
making excel work like a mail merge | Excel Worksheet Functions | |||
Merge mail excel to word | Excel Discussion (Misc queries) | |||
Word mail merge with Excel data | Excel Worksheet Functions |