I am not making form letters or lables. I want to insert a table of data into Word from Access.
Is there anyway without using ADO or complex VBA to insert the results of an Access 2007 query into a Word doc? Can you make a link in a Word doc to the Access file including the name of a query in the Access file? This does not have to be a live link (allowing editing in Word to affect the Access file), but I do need to be able to get fresh data from Access into Word when I want to make sure it's up to date in Word.
I have been told to use the Mail Merge Directory option, but what optons do I pick ith the Data Connection Wizard? What's the difference between using the Microsoft Jet 4.0 OLE DB Provider & the Microsoft Office 12.0 Access DAtabase Engine OLE DB Provider? If I use the Microsoft Office 12.0 Access DAtabase Engine OLE DB Provider, how do I specify my Data Source?
(I don't want to use Access to make the doc & export it to Word because people I work do not use Access & they need to be able to edit the text in this Word doc.)