Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Letter doc and Excel 2003 data source
I've created a Word 2003 letter and envelope doc in word to read from an
Excel 2003 data source. I have all the proper labels at the top of each column (no special characters or spaces). When I tell Word that the data source is an Excel spreadsheet, and click ok; it keeps coming back to the same dialog box. If I click cancel it gives me an error message "this operation cannot be completed because of dialog or database engine failures". This second problem is that when I can get connected to the database and try to select my merge receipents it says that "the connection to the receipent's list has been lost. Check that the file has not been moved or deleted and that the network location is accessible". Can anyone tell me, what I'm doing wrong or is there some setting on my computer or network server that needs to be changed? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Letter doc and Excel 2003 data source
Try changing the type of document back to a Normal Word document, save it,
close it, then open it again and then change it back to a formletter type mail merge main document and then try to re-attach the data source. If that does not overcome the problem, from the Tools menu, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the datasource, a dialog box will appear asking you for the method by which the connection should be made. Try the DDE option. It is older technology, but it does sometimes overcome problems. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barnie M" wrote in message ... I've created a Word 2003 letter and envelope doc in word to read from an Excel 2003 data source. I have all the proper labels at the top of each column (no special characters or spaces). When I tell Word that the data source is an Excel spreadsheet, and click ok; it keeps coming back to the same dialog box. If I click cancel it gives me an error message "this operation cannot be completed because of dialog or database engine failures". This second problem is that when I can get connected to the database and try to select my merge receipents it says that "the connection to the receipent's list has been lost. Check that the file has not been moved or deleted and that the network location is accessible". Can anyone tell me, what I'm doing wrong or is there some setting on my computer or network server that needs to be changed? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Letter doc and Excel 2003 data source
Thanks Doug. Tried all of the above. I finally deleted the document and
started over from scratch. Did ToolsOptionGeneral and select the conversion option and it seems to be working now. But I'll try again tomorrow morning and see if the problem comes back, as it seems to come and go. "Doug Robbins - Word MVP" wrote: Try changing the type of document back to a Normal Word document, save it, close it, then open it again and then change it back to a formletter type mail merge main document and then try to re-attach the data source. If that does not overcome the problem, from the Tools menu, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the datasource, a dialog box will appear asking you for the method by which the connection should be made. Try the DDE option. It is older technology, but it does sometimes overcome problems. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Barnie M" wrote in message ... I've created a Word 2003 letter and envelope doc in word to read from an Excel 2003 data source. I have all the proper labels at the top of each column (no special characters or spaces). When I tell Word that the data source is an Excel spreadsheet, and click ok; it keeps coming back to the same dialog box. If I click cancel it gives me an error message "this operation cannot be completed because of dialog or database engine failures". This second problem is that when I can get connected to the database and try to select my merge receipents it says that "the connection to the receipent's list has been lost. Check that the file has not been moved or deleted and that the network location is accessible". Can anyone tell me, what I'm doing wrong or is there some setting on my computer or network server that needs to be changed? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge labels with Word 2003 and Excel 2003 Data lost data | Mailmerge | |||
Winword 2003 on MS Server 2003 keeps losing data source. | Mailmerge | |||
Word 2003 merge data source Excel Ques | Mailmerge | |||
Create a reporti n word 2003, using data in Excel 2003 | Microsoft Word Help | |||
Form Letter In Word / Data Source in Excel ... cannot edit records | Mailmerge |