When I try to open my Word Main Document, a dialog box opens with this
prompt " Master Purchase Requisition.doc is a mail merge maind document. Word
cannot fints its data source, C:\...\DataForPurchaseRequisition.xls."
When I click the "Find Data Source" button of the above dialog box, another
dialog box entitled "Select Table" appears. I navigated this second dialog
box until I find the relevant Excel Spreadsheet and then click "OK".
After this, however, the first dialog box re-surfaces. I repeated the whole
process and sometimes, another dialog box with the prompt "Word cannot open
the data source" would pop-up.
I hope someone will be able to help me with this.
Thank you very much.
"oykeong" <oyk...@discussions.microsoft.com> wrote in message
news:97920103-50CD-448F...@microsoft.com...
Thanks for responding. Initially, the whole mail merge was working
fantastically. As a matter of fact, it had been working for the past one year
or so. But when I opened it just two days ago, the "Word cannot find its
data source" dialog box popped up. From thence onwards, it was not possible
to connect to the data source, as described in my post above.
As for my Excel spreadsheet, I have opened it separately and it functions
perfectly. I can edit, delete, add records etc. etc. It definitely is working
normally. I am very sure of that.
Thanks again for your willingness to help.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"oykeong" <oyk...@discussions.microsoft.com> wrote in message
news:2B6767C6-DC8F-4C9F...@microsoft.com...
I managed to solve my problem as follows:-
1. Tools>Options>General>Confirm Conversion at Open
2. Then when the Confirm Data Source dialog box appears, I chose Microsoft
Excel Worksheet via Converter
I manged to connect to the data source. However, it seemed to be slower
compared to earlier. But at least it worked.
Thanks anyway for your willingness to help.
Re. the converter, be warned that Microsoft has now dropped the Excel
converter, i.e. if you ever got a new machine with (say) Office 2003 you
wouldn't find the converter in Office or the converter pack. I believe
there's a copy on Graham Mayor's site www.gmayor.com
--
Peter Jamieson
http://tips.pjmsn.me.uk
"oykeong" <oyk...@discussions.microsoft.com> wrote in message
news:AF103C6F-B589-44A5...@microsoft.com...