Home > Data Source > Word Was Unable To Open The Data Source Excel

Word Was Unable To Open The Data Source Excel

Contents

Suppose you have { MERGEFIELD mypercentage } Select it, and press ctrl-F9 to surround it with a new pair of field code braces: { { MERGEFIELD mypercentage } } then insert This does not make sense to me. Your Excel workbook has changed (possibly even been corrupted) in a way that makes it impossible for the Access/Jet OLE DB provider to get the data. James4630, Dec 13, 2009 #2 redoak Gone but never forgotten Joined: Jun 24, 2004 Messages: 6,782 Click "Report" and request your Thread be transferred as mentioned below. {redoak} redoak, Dec weblink

However, when I use a path like \\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1accept43\word_us I still get asked to confirm the data source when opening the template but it doesn't recognise this path and asks me to ensure that Excel is listening to DDE conversations (Ensure that Excel Tools-Options-General-Ignore other Applicaitons is unchecked) b. It is certainly possible for Internet Explorer or a plug-in to interfere with DDE as a whole. The error appears when batch letters are created in an application written in Delphi.

Word 2013 Word Was Unable To Open The Datasource

EDIT: I copied a template that works to the same folder as the template giving the issue. Reply With Quote Quick Navigation Office Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6 I haven't checked this myself. Microsoft Office Forums > Microsoft Word > Mail Merge "word was unable to open the data source" error User Name Remember Me?

Please let me know if there is any further information on this from your experiences. Then in lowr left task bar it briefly says "Opening file . . . ." but then I am prompted with Word error "Word was unable to open the data source." Join over 733,556 other people just like you! Word 2013 Mail Merge Unable To Open Data Source For the first problem, use Alt-F9 to display the field codes.

are your mail merge document and data source in the same network folder? Word was unable to open the data source « Previous Thread | Next Thread » Thread Tools Display Modes #1 February 5th 10, 03:15 AM posted to The application makes use of word merge fields in batch letters. If it uses OLE DB, it generates a "connection string" which contains the path name of the folder containing the file.

Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Mail Merge Can't Open Data Source So for example, if the data source is... The OLE DB provider typically divides the location of a data source into a "database" and a "table". The data is a simple csv file with only 10 fields.

Word 2016 Was Unable To Open The Data Source

I am far from an expert in VBA, I havn't even been using it for 4 months, so I could be missing the issue/point entirely. Is it Vista? 2. Word 2013 Word Was Unable To Open The Datasource Our Word Merge templates (the 'letter' part of the file) are copied into a client directory, and staff edits the file to 'link' to the new data source (text file with Word Was Unable To Open The Data Source Word 2010 Reply With Quote Apr 25th, 2010,05:05 AM #4 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 22,072 Re: MailMerge: Word is Unable to Open Data Source Would

I also tried copying the issue template to the same folder as another template that works, and this also did not work. have a peek at these guys The time now is 05:31 AM. -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top Powered by vBulletin Version 3.8.1Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. you open the Word document b. A few questions: a. Word Was Unable To Open The Data Source Mac

If I attached a data source that's on my local drive to the word file, there is no problem - the merge file with the new data source saves fine. there are no filters or sorts "Peter Jamieson" wrote: On Tuesday, August 21, 2007 10:50 AM Peter Jamieson wrote: OK, I checked again with a similar length pathname and it does The preconditions are correct, i.e. check over here TOGG replied Dec 23, 2016 at 6:53 AM Laptop Recomondations Technologyishard replied Dec 23, 2016 at 6:48 AM AMD driver stopped working and...

To start viewing messages, select the forum that you want to visit from the selection below. Kingsoft Writer Cannot Open Data Source One of the following will happen: 1. Peter Jamieson wrote in message news:[email protected] On Monday, August 20, 2007 11:38 AM Jan wrote: I'm having a very similar problem.

I would be looking at the permissions for the /share/ and for the underlying folder - e.g.

unless you happen to know that 0 always means that the original entry was blank. Peter Jamieson http://tips.pjmsn.me.uk On 05/02/2010 02:15, rickcstahl wrote: My problem is that my Excel data is not being "mail merged" into Word. If you see \*Mergeformat in there, delete it. Mail Merge Will Not Open Data Source Which version of Windows?

i was doing a mail merge with a word document (.doc) with a table. Track this discussion and email me when there are updates If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and Any help to correct this is greatly appreciated. . . http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-excel-2007.html For the second problem you can change { MERGEFIELD mynumber } to { MERGEFIELD mynumber \#"0.00;-0.00;''"} (or if it is your percentage field that can have blanks, use { ={ MERGEFIELD

However, if I make a new csv file in notepad and make the names with an _, it works fine. Staff saves the document. Is it Vista? 2. {{offlineMessage}} Try Microsoft Edge, a fast and secure browser that's designed for Windows 10 Get started Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone

Set up the data source how you want it, then save the mail merge main document. give your data source a shorter name, or put it in a folder with a shorter pathname, depending on exactly what typ eof data source it is. is cached in the .doc. Show Ignored Content As Seen On Welcome to Tech Support Guy!

Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required further, it actually emailed better and faster (i have to use a hotfix to email from word mail merge to live mail desktop email program). When I do find the source I return to the "Find" prompt again and again!!! Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge Word was unable to open the data source Author Name Remember Me?

Here's the strange part. Advertisement nancy4 Thread Starter Joined: Dec 12, 2009 Messages: 3 I am making mail merge address labels. Copyright 2004-2016 Microsoft Office Word Forum - WordBanter.