excel 2003: mail merge issue
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. |
excel 2003: mail merge issue
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. |
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. |
excel 2003: mail merge issue
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. |
All times are GMT +1. The time now is 07:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com