Excel XP file in Word XP mail merge

Y

Yves Leclerc

I have a client where the Word XP mail merge no longer seems to able to
access an Excel XP file for use as the data source in the mail merge. I
need to re-format the file by opening the file with "Format for mail merge"
option in Word first and saving it. Then, doing the mail merge with this
re-formatted file works.

How can I get the file to open directly in mail merge?
 
P

Peter Jamieson

What goes wrong? Are you specifying any particular connection method? Is the
file open in Excel at the time when you merge? Do you get the same problem
with all Excel data sources, or just this one? If it's just this one, the
Excel file may have been corrupted and it may be worth trying to reconstruct
it from scratch
 
Y

Yves Leclerc

The file is closed in Excel and Excel is closed.
Whenever mail merge open the data source, it is asking for: Format, Table,
View...
This seesm to be asking how to open the file as an Access data base, which
it is not.

Y.

Peter Jamieson said:
What goes wrong? Are you specifying any particular connection method? Is
the
file open in Excel at the time when you merge? Do you get the same problem
with all Excel data sources, or just this one? If it's just this one, the
Excel file may have been corrupted and it may be worth trying to
reconstruct
it from scratch
Click to expand...
 
P

Peter Jamieson

Do you see this problem with all Excel data sources, or just this one?

Although I do not think that this is directly relevant to your question,
when Word opens a data source using OLEDB (the default in Word 2002/2003) it
does perceive the data source to be structured as a set of Tables and Views
rather than (e.g.) Sheets and Named ranges. So the user interface for
connecting to an Excel data source and an Access data source may be very
similar.

--
Peter Jamieson

Yves Leclerc said:
The file is closed in Excel and Excel is closed.
Whenever mail merge open the data source, it is asking for: Format, Table,
View...
This seesm to be asking how to open the file as an Access data base, which
it is not.

Y.

Peter Jamieson said:
What goes wrong? Are you specifying any particular connection method? Is
the
file open in Excel at the time when you merge? Do you get the same problem
with all Excel data sources, or just this one? If it's just this one, the
Excel file may have been corrupted and it may be worth trying to
reconstruct
it from scratch
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Mail Merge Directory Conditional Page Break 0
Merge Excel file into Word Document 3
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Mail Merge skipping records/sending one at a time 0
Mail Merging into PowerPoint 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top