Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-31-2019, 07:14 AM
JennEx JennEx is offline Mail Merge No Longer Working - Unable to Recognize DATA Source Windows XP Mail Merge No Longer Working - Unable to Recognize DATA Source Office 2013
Competent Performer
Mail Merge No Longer Working - Unable to Recognize DATA Source
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Mail Merge No Longer Working - Unable to Recognize DATA Source

I am having issues with accessing the .xlsx data I use with my mail merge document.

When I open the document, I am greeting with ...

"Opening this document will run the following SQL command:
SELECT * FROM 'DATA$' WHERE 'TYPE' = 'FR'
Data from your database will be placed in the document. Do you want to continue?"

On selecting yes I get ...

"Error has occured: Class not registered."

I press OK and get this dialogue:

"FR15NG.docx" is a mail merge main document. Word cannot find its data source, U:\Education\....\Dates\Data\May-25 (Sat) schedule_5.xlsx

I press the FIND DATA SOURCE button, and the Select Data Source dialogue open. It's source directory is defaulted to "C:\Users\me\Documents\My Data Sources" and lists two .odc file.

The File Name is populated with "May-25 (Sat) schedule_5".

I change the file type to .xlsx and navigate to and select the source file from it's directory. (The file exists where it is supposed to be!), and press OPEN.

The Select Table dialogue opens up. in the window I would expect to see the worksheet DATA (the source of the mail merge data 'DATA$'), it is empty. The workbook field is populated with "U:\Education\Schools\School Admin\Timetables\Dates\DATA.xls"

I have no idea what is going on as DATA.xls is not a workbook, and not the workbook I referenced to find the data.

Is anyone able to tell me what has gone wrong? Everything worked as expected for months before today. Last night the IT department did some things to my computer, including the removal of Office 2010 from it as Office 2016 was also installed. So, I wonder if that is a significant contributing factor.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge No Longer Working - Unable to Recognize DATA Source Mail Merge - Cannot Locate Source Data Karen615 Mail Merge 2 08-03-2018 05:40 PM
Mail Merge using HTML Data Source chadnewman Mail Merge 0 09-21-2017 07:14 AM
Mail Merge No Longer Working - Unable to Recognize DATA Source Migrating Mail Merge Data Source jameswang Mail Merge 2 06-07-2015 03:03 AM
Mail Merge No Longer Working - Unable to Recognize DATA Source Enable Mail Merge Data Source always in same folder alleycat1998 Mail Merge 1 04-10-2013 03:02 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft