If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail merge - won't open Excel data source
Trying to do a simple mail merge in Word 2000 which I've had set up for
years. My usual data source is an Excel spreadsheet. However, when I try to change the data source (Tools/Mail Merge/Get Data/Open Data Source) to another Excel spreadsheet, it simply says 'Word was unable to open the data source'. It works fine with every other Excel spreadsheet I have - it's just this one which won't work. Any ideas? I'd be very grateful. Thanks. |
#2
|
|||
|
|||
Hi =?Utf-8?B?RWQgV2lsbGlhbXNvbg==?=,
It's possible that the Excel workbook's file structure is damaged; it doesn't happen often, but it's not unknown. If you copy/paste the cells to a new workbook, will mail merge link to it? If not you can try copying/pasting to Word (use paste special and paste in RTF format), then copy/paste that into a new Excel workbook. Trying to do a simple mail merge in Word 2000 which I've had set up for years. My usual data source is an Excel spreadsheet. However, when I try to change the data source (Tools/Mail Merge/Get Data/Open Data Source) to another Excel spreadsheet, it simply says 'Word was unable to open the data source'. It works fine with every other Excel spreadsheet I have - it's just this one which won't work. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
refresh data source for mail merge document | T Perkon | Mailmerge | 2 | November 12th, 2004 05:29 AM |
How do I mail merge excel data to printable labels for envelop | Judy | Mailmerge | 1 | September 24th, 2004 10:01 AM |
Retaining source formatting from Excel with a mail merge in Word | Drew | General Discussion | 2 | August 18th, 2004 07:34 AM |
mail merge data source | Randy | Contacts | 4 | May 31st, 2004 02:58 AM |
Mail merge looks for addresses in Outlook instead of data source | Karen | Mailmerge | 4 | May 21st, 2004 09:07 AM |