Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
maryj
 
Posts: n/a
Default Problems connecting to Excel data source

Using Office 2003/WinXP. Have used this mail merge for a long time connected
to the same Excel data source. Now the Word doc won't connect to the data
source. I've even tried to connect to the same Excel data source with a brand
new Word doc - it just won't connect. I get to the place to locate the data
source, select the file and then it just stops - no errors, but it doesn't
give me the option to select the fields from the file. Changed the setting in
Word to prompt for conversion options and have tried all of them DDE, etc.
but still same thing. Any other suggestions?
--
maryj
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Problems connecting to Excel data source

I've even tried to connect to the same Excel data source with a brand
new Word doc - it just won't connect.


Have you tried connecting your Word document with a completely new Excel
data source that has the same columns as the existing source? If that works,
it suggests that the existing Excel source document is probably corrupt and
you may need to re-construct it. If it doesn't work, it sounds as if
something more serious has happened to Excel - it might be worth checking in
an Excel group for ideas before, e.g. making sure you have yourOffice setup
CDs and using the Check and Repair option.

Peter Jamieson
"maryj" wrote in message
...
Using Office 2003/WinXP. Have used this mail merge for a long time
connected
to the same Excel data source. Now the Word doc won't connect to the data
source. I've even tried to connect to the same Excel data source with a
brand
new Word doc - it just won't connect. I get to the place to locate the
data
source, select the file and then it just stops - no errors, but it doesn't
give me the option to select the fields from the file. Changed the setting
in
Word to prompt for conversion options and have tried all of them DDE, etc.
but still same thing. Any other suggestions?
--
maryj



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
Numeric rounding problems in mail merge with excel data source. Mark Mailmerge 2 January 12th 06 12:41 PM
Unable to change data source [email protected] Mailmerge 0 October 12th 05 06:02 PM
Mail Merge using an Excel spreadsheet as a data source SharronTucker Microsoft Word Help 2 June 24th 05 06:11 PM
"Word was unable to open the Excel data source" Asp.net Mailmerge Shalini Mailmerge 8 June 23rd 05 02:09 AM
mail merge using excel file as data source Laurina Mailmerge 1 January 31st 05 04:10 PM


All times are GMT +1. The time now is 11:28 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"