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

Word Was Unable To Open Data Source

Contents

First, the original template with the mail merge fields unfilled, and the second is the template after the merge is complete. The letters are created seperately in turn and then appended to each other as each letter has a unique barcode inserted so the mail merge data source is recreated by the This is tedious, but it may help. 3. Michael Suttkus, II Mailmerge 3 November 16th 05 03:29 PM Unable to open excel data source for word mail merge Trisha Microsoft Word Help 0 October 18th 05 10:59 AM "Word his comment is here

What do I need to do to fix it and why did that change? I am not sure about all of the zeros in Word that should be there, but I know some originate from blank fileds formated as either General or Text in Excel. Next I choose th named or cell range which is "Entire Spreadsheet". that may be because...

Word 2013 Word Was Unable To Open The Datasource

All times are GMT -5. SHOW ME NOW © CBS Interactive Inc.  /  All Rights Reserved. You can fix this problem by using "formatting switches" in Word: numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word. Your cache administrator is webmaster.

Microsoft Customer Support Microsoft Community Forums TechCenter   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 Occassionally certain control characters cropped up in the barcode that threw up an error when using mail merge. I renamed the copied template to have the same name, and copy/pasted the contents of the issue template. Word Was Unable To Open The Data Source Mac Specifically, numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word.

I didn't do anything different that I have before. Word 2016 Was Unable To Open The Data Source Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page... unless you happen to know that 0 always means that the original entry was blank. Peter Jamieson View Public Profile View message headers Find all posts by Peter Jamieson Find all threads started by Peter Jamieson « Previous Thread | Next Thread » Thread Tools

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 Mail Merge Can't Open Data Source Last edited by krazykarter; Apr 26th, 2010 at 11:00 AM. When I select recipents and select the excel spreadsheet, it asks what table I want to use, so I select the spreadsheet I want, as that is the only options, after Copyright 2004-2016 Microsoft Office Word Forum - WordBanter.

Word 2016 Was Unable To Open The Data Source

Also, blank fields in Excel dispay the value zero (0) when merged in Word. Another way to try to get the data as you see it in Excel is to Edit-Copy the data from the worksheet and paste it into a Word document, then use Word 2013 Word Was Unable To Open The Datasource I have used the excel spreadsheet for this purpose before, but I get a message that "word cannot open the data source". Word Was Unable To Open The Data Source Word 2010 I haven't checked this myself.

by Kees Bakker / August 27, 2009 6:39 AM PDT In reply to: "word was unable to open the data source" error message But I wondered why when I read "each http://webinweb.net/data-source/word-is-unable-to-open-the-data-source.html However, when I Finish& Merge, the data merged into Word look different than what it should and how it appears in Excel. click Options and select all four checkboxes. the file path, template name, etc.. 3. Word 2013 Mail Merge Unable To Open Data Source

Here are the document properties: Attached Images 2014-03-14 14_30_41-Microsoft Excel - Mail Merge.jpg (32.8 KB, 7 views) #4 03-14-2014, 12:40 PM macropod Windows 7 32bit Office 2010 32bit Administrator As far as the zeros being displayed, sometimes I have zero as an Excel value which I want to appear in Word but other fields in Excel are blank but when Is it Vista? 2. weblink Privacy statement  © 2016 Microsoft.

Exchange knowledge, and get help on all the latest office software and productivity tools--from various office suitesword processing to spreadsheets.Real-Time ActivityMy Tracked DiscussionsFAQsPoliciesModerators General discussion "word was unable to open the Kingsoft Writer Cannot Open Data Source Specifically, numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word. I did try opening the Excel file first but this did not work.

To start viewing messages, select the forum that you want to visit from the selection below.

I am not sure about all of the zeros in Word that should be there, but I know some originate from blank fileds formated as either General or Text in Excel. Please try again now or at a later time. It appears after a couple of letters are processed, but there is no pattern to when it appears. Mail Merge Will Not Open Data Source 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

Solved: word cannot open excel data source Discussion in 'Business Applications' started by nancy4, Dec 12, 2009. Wednesday, December 10, 2014 6:01 AM Reply | Quote Answers 0 Sign in to vote As far as I know, you cannot merge from a .xlsx data source in Mac Word Loading... http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-dbf.html For example (assuming you're still getting the SQL prompt upon opening the document), when the 'Data Link Properties' dialogue pops up, simply add the missing 'x' to the end of the

All submitted content is subject to our Terms of Use. rickcstahl View Public Profile View message headers Find all posts by rickcstahl Find all threads started by rickcstahl Ads #2 February 5th 10, 09:45 AM posted to microsoft.public.word.mailmerge.fields Peter As far as the zeros being displayed, sometimes I have zero as an Excel value which I want to appear in Word but other fields in Excel are blank but when I did try opening the Excel file first but this did not work.

However, when I Finish & Merge, the data merged into Word look different than what it should and how it appears in Excel. I haven't checked this myself. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More...