excel 2003: mail merge issue
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.
|