Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
Has this just stopped working?
If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
Hey Peter,
How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
How do I get to a previous version?
Only possible if you had a backup, which does not appear to be the case! -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... Hey Peter, How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
This is the first time I am trying to do a mailmerge since the Hard drive
crashed. Reinstalled Office 97. Restored backup documents that were created w/ 97. (however, I updated excel to a more current version) "Peter Jamieson" wrote: How do I get to a previous version? Only possible if you had a backup, which does not appear to be the case! -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... Hey Peter, How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
SO what happened when you did the experiment?
-- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... This is the first time I am trying to do a mailmerge since the Hard drive crashed. Reinstalled Office 97. Restored backup documents that were created w/ 97. (however, I updated excel to a more current version) "Peter Jamieson" wrote: How do I get to a previous version? Only possible if you had a backup, which does not appear to be the case! -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... Hey Peter, How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
Got the same error message.
"Peter Jamieson" wrote: SO what happened when you did the experiment? -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... This is the first time I am trying to do a mailmerge since the Hard drive crashed. Reinstalled Office 97. Restored backup documents that were created w/ 97. (however, I updated excel to a more current version) "Peter Jamieson" wrote: How do I get to a previous version? Only possible if you had a backup, which does not appear to be the case! -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... Hey Peter, How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
Now, suddenly, I can't open an Excel document.
I says: "Windows can't find it" "Peter Jamieson" wrote: SO what happened when you did the experiment? -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... This is the first time I am trying to do a mailmerge since the Hard drive crashed. Reinstalled Office 97. Restored backup documents that were created w/ 97. (however, I updated excel to a more current version) "Peter Jamieson" wrote: How do I get to a previous version? Only possible if you had a backup, which does not appear to be the case! -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... Hey Peter, How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
Peter,
Also put data into a new worksheet......Windows can't find it either. I can, however still open it when clicking on file, open. But when I click on the doc to open it, Windows can't find it. "Peter Jamieson" wrote: SO what happened when you did the experiment? -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... This is the first time I am trying to do a mailmerge since the Hard drive crashed. Reinstalled Office 97. Restored backup documents that were created w/ 97. (however, I updated excel to a more current version) "Peter Jamieson" wrote: How do I get to a previous version? Only possible if you had a backup, which does not appear to be the case! -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... Hey Peter, How do I get to a previous version? (I will do test you suggest) Thanks for responding "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
When I MailMerge Excel into Word...
Word and Excel are both 97.
This started after hard drive crashed. Got a new one, loaded Office 97 CD, updates. Word and Excel docs are from a backup made with same Office 97. "Peter Jamieson" wrote: Has this just stopped working? If so, can you go back to a previous version of your Excel sheet? If not, can you experiment by creating a very simple Excel spreadsheet (say, with 2 columns, one row containing headers and two rows of data) and using that as the data source for a merge? If you can get that to work, it suggests that there may be something wrong with your Excel sheet: if it is simple enough to export as .csv format and re-import into a new sheet, try that. Otherwise you may have to recreate the sheet from scratch or fiind another way to merge the data. -- Peter Jamieson http://tips.pjmsn.me.uk "STEVE" wrote in message ... I get an error: "can't open data source". I have Office 97, did the SR2 update. Any suggestions please? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DDE mailmerge between Word and Excel | Microsoft Word Help | |||
excel--to-excel linked cells not updated in word mailmerge | Mailmerge | |||
mailmerge using Word/Excel 500.00 in Excel shows as 500 nt 500.00 | Mailmerge | |||
Word/Excel Mailmerge | Mailmerge | |||
mailmerge from excel into word | Mailmerge |