I have a database with several tables, and recent created a new table for the
latest fiscal year. The old documents which have run the previous tables
will not accept the new table for mail merges.

I open a data source... find the spreadsheet, then select the table, then
the computer asks me to select a table from a list of previous formats where
I do a select of previous tables to for some special formatting.

It's confusing as all get out. How can I get this mail merge to work and
hook it up with the data source.

Hi,

You are doing this in Word? If so you should probably get a better answer
from the Word gurus.

But here is my guess. Change the Files of Type to Excel Files (*.xls) in
the Select Data Source dialog box. Then navigate to find your file ...
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"shanna" wrote:

I have a database with several tables, and recent created a new table for the
latest fiscal year. The old documents which have run the previous tables
will not accept the new table for mail merges.

I open a data source... find the spreadsheet, then select the table, then
the computer asks me to select a table from a list of previous formats where
I do a select of previous tables to for some special formatting.

It's confusing as all get out. How can I get this mail merge to work and
hook it up with the data source.

My database is in Excel. My letter is in Word. There's something messing
with the Excel sheet that's inteferring with the hookup, and making me use a
named range. was able to use the named range, but some of the information
came out cooky. I will have to convert some of the numbers to text cells.
I may have to re-enter the entire spreadsheet manually at this point.

"Shane Devenshire" wrote:

Hi,

You are doing this in Word? If so you should probably get a better answer
from the Word gurus.

But here is my guess. Change the Files of Type to Excel Files (*.xls) in
the Select Data Source dialog box. Then navigate to find your file ...
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"shanna" wrote:

I have a database with several tables, and recent created a new table for the
latest fiscal year. The old documents which have run the previous tables
will not accept the new table for mail merges.

I open a data source... find the spreadsheet, then select the table, then
the computer asks me to select a table from a list of previous formats where
I do a select of previous tables to for some special formatting.

It's confusing as all get out. How can I get this mail merge to work and
hook it up with the data source.

Hi,

Remember Excel's formats don't carry over to Word, but there are ways to
handle this in Word. You should post those problems to the Word list.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Shanna" wrote:

My database is in Excel. My letter is in Word. There's something messing
with the Excel sheet that's inteferring with the hookup, and making me use a
named range. was able to use the named range, but some of the information
came out cooky. I will have to convert some of the numbers to text cells.
I may have to re-enter the entire spreadsheet manually at this point.

"Shane Devenshire" wrote:

Hi,

You are doing this in Word? If so you should probably get a better answer
from the Word gurus.

But here is my guess. Change the Files of Type to Excel Files (*.xls) in
the Select Data Source dialog box. Then navigate to find your file ...
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"shanna" wrote:

I have a database with several tables, and recent created a new table for the
latest fiscal year. The old documents which have run the previous tables
will not accept the new table for mail merges.

I open a data source... find the spreadsheet, then select the table, then
the computer asks me to select a table from a list of previous formats where
I do a select of previous tables to for some special formatting.

It's confusing as all get out. How can I get this mail merge to work and
hook it up with the data source.