excel 2003: mail merge issue

[shanna]

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.

 

[Shane Devenshire]

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 ...

 

[Shanna]

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]

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.