Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
hroberts hroberts is offline
external usenet poster
 
Posts: 1
Default Mail Merge - Cannot open data source

I'm trying to mail merge a word document with an excel spreadsheet. When I
select recipents and select the excel spreadsheet, it asks what table I want
to use, so I select the spreadsheet I want, as that is the only options,
after I select it, it asks the same question again, but gives no choice of
spreadsheet. Then it tells me that it cannot open the data source.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail Merge - Cannot open data source

It sounds as if what is happening is that Word is successfully opening
the workbook using its default method (OLE DB), but failing to open the
worksheet, then falling back to trying to use ODBC. If you are seeing
the ODBC dialog box you would typically need to
a. verify that the selected "database" is the excel filethat you
expect. That's not always easy because the dialog box does not show long
path names properly
b. click Options and select all four checkboxes.

However, the chances are that if Word can't open using OLE DB, it won't
be able to do it with ODBC either. that may be because...

Your Excel workbook has changed (possibly even been corrupted) in a way
that makes it impossible for the Access/Jet OLE DB provider to get the
data.

Things you might have done to your workbook that could affect this
include stuff such as creating lists/databases/outlines within the
relevant worksheet

If your workbook/worksheet is very simple (e.g. just a rectangular table
of data with no formulas etc.) it is probably worth exporting your data
to a format such as .csv, then recreating your workbook and re-importing
the data.

If none of the above helps, a possible short term workaround is to
copy/paste your Excel data into a new Word document and use that as the
data source for your merge (depending on how many columns your worksheet
has, you may find that the copy/paste creates a word table or a set of
tab-delimited Word paragraphs).

Peter Jamieson

http://tips.pjmsn.me.uk

On 03/12/2009 18:45, hroberts wrote:
I'm trying to mail merge a word document with an excel spreadsheet. When I
select recipents and select the excel spreadsheet, it asks what table I want
to use, so I select the spreadsheet I want, as that is the only options,
after I select it, it asks the same question again, but gives no choice of
spreadsheet. Then it tells me that it cannot open the data source.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
message in Word mail merge - cannot open data source patgar Mailmerge 1 October 9th 07 11:11 PM
Word cannot open .dbf source data for mail merge hjcoombs Mailmerge 3 September 12th 06 09:19 AM
Mail Merge - Word cannot open data source Monica Mailmerge 3 January 1st 06 11:49 AM
When I open the data source for a mail merge Word freezes..HELP Tiff Mailmerge 3 October 27th 05 02:53 PM
Mail merge will not let me open my data source, why? I get an err ICEE Mailmerge 1 August 4th 05 10:22 PM


All times are GMT +1. The time now is 01:27 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"