Microsoft Office

How to Use Automation to perform the merge from Access to Word 97  August 29, 2013 – 00:25
Sciffer Technologies | ERP Consultancy & Development | MS Office

Advanced: Requires expert coding, interoperability, and multiuser skills. This article shows you how to use Automation to run a Microsoft Word 97 for Windows mail merge in Microsoft Access version 7.0 or 97.

For information about how to perform a mail merge in Word 7.0 Microsoft Access 7.0, please see the following article in the Microsoft Knowledge Base:

154571 (

Word 97 uses Visual Basic for Applications object hierarchy used in other Microsoft Office applications. Word 7.0 and earlier uses a simple model called WordBasic command. By using Automation, you can perform a mail merge in a Microsoft Word 97 to Microsoft Access. The example in this article uses the methods of object's Execute OpenDataSource and MailMerge in Word 97.

Example: Joining a Microsoft Access Query with a Word 97 document

  1. Start Microsoft Access and open a database or create a new one.
  2. Create a module and type the following procedure:

    Function MergeIt () As Word.Document Dim objWord September objWord = GetObject ("C: \ MyMerge.doc", "Word.Document") 'Make Word visible. objWord.Application.Visible = True 'Set the mail merge data source as the Northwind database. objWord.MailMerge.OpenDataSource _ Name: = "C: \ Program Files \ Microsoft" & _ "Office \ Office \ Samples \ Northwind.mdb", _ LinkToSource: = True, _ Connection: = "TABLE Customers", _ SQLStatement: = "Select * from [Customers]" 'Execute the mail merge. objWord.MailMerge.Execute End Function

    Note: If you want to print the merged document, delete the previous EXECUTE statement and add the following four lines of code above the End Function statement:

    objWord.MailMerge.Destination = wdSendToNewDocument objWord.MailMerge.Execute 'The Following line must follow the Execute statement Because The 'PrintBackground property is available only When a document window is 'Active. Without this line of code, the function will end before Word 'Can print the merged document. objWord.Application.Options.PrintBackground = False objWord.Application.ActiveDocument.PrintOut

  3. The module is still open in Design view, click References on the Tools menu. Add to the list of available references to the object library Word 97. If the object library is not listed, click the Browse button and locate the file Msword8.olb.
  4. To test this function, type the following line in the Debug window, and then press ENTER:

    ? MergeIt ()

    An instance of Word 97 is opened, displays MyMerge.doc and then are combined with the Customers table in the sample database Northwind.mdb.

, oppure avviare l'Assistente di Microsoft Access 97. For more information about Automation, search the Help Index for automation, or ask the Microsoft Access 97 Office Assistant. o chiedere l'Assistente di Microsoft Access 97. For information about using Microsoft Access Object Browser to explore the methods and properties of Microsoft Word 97 Visual Basic objects of applications, search the Help Index for automation, using the Object Browser or ask the Microsoft Access 97 Office Assistant .

Article ID: 159328 - Last Review: January 19, 2007 - Revision: 3.3

  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
  • Microsoft Word 97 Standard Edition

Source: книга palm treasure.

You might also like:

Word 2008 Quick Letterhead
Word 2008 Quick Letterhead

That's nice.

How exactly do your web based operating system independent applications deal with seamless automation of Microsoft office products? Furthermore, what makes learning VBA mutually exclusive from learning .NET? VBA pays good money today and will continue to pay good money for at least another few years.
You seem really, really, REALLY mired in your own career path and unable to envision any other possible way to make money.

A novice's guide to backing up a PC  — ITProPortal
There's also an Outlook 2007/2003/2002 add-in from Microsoft called Personal Folders Backup that does just what it says. Follow these instructions from ..

EXACT LEVERAGES MICROSOFT .NET TECHNOLOGY.: An article from: Manufacturing Automation
Book (Vital Information Publications)

Related posts:

  1. Microsoft Office Automation, Software
  2. Microsoft Office Automation Security
  3. Microsoft Office Automation Support
  4. Microsoft Office Automation tools
  5. Microsoft Office Automation Word

  • Avatar Andrea S Has anyone tested out of a Computer and Office Automation course?
    Oct 21, 2010 by Andrea S | Posted in Higher Education (University +)

    I m pretty good at teaching myself how to use Microsoft Office and want to know what I need to know in order to test out of Computer and office Automation. I m attending Harrison College and they won t give me details so I can t learn it on my own. The test out fee is $45 and I don t want to pay then fail over something simple. Thanks!

    • The description below applies to the CLEP test for this subject: Information Systems & Computer Applications Description of the Examination The Information Systems and Computer Applications examination covers material that is usually taught in an introductory college-level business information systems course. Questions test knowledge, terminology, and basic concepts about information systems as well as the application of that knowledge …

  • Avatar Carl 1) Two information systems that support the entire organization are A. enterprise resource planning systems an?
    Jun 24, 2012 by Carl | Posted in Small Business

    1) Two information systems that support the entire organization are A. enterprise resource planning systems and dashboards B. transaction processing systems and office automation systems C. enterprise resource planning systems and transaction processing systems D. expert systems and office automation systems 2) is the direct use of information systems by employees in their work A. Transaction processing systems B. End-user computing C. Decision …

    • Copy and paste this link to get the answers for BIS/220 Final Exam:

  • Avatar Afreen Afroze Is this company Fake?
    Jun 06, 2012 by Afreen Afroze | Posted in Corporations

    Hello Every One One of my friends forced me to take membership in an edupreneur company, It is corevision edupreneurs pvt ltd.. it even has its website It provides three packages 1. Free e-educational package The following are the contents of the package Free e- Educational Package consists of: Computer Courses. 1)Windows 98 2)Windows XP 3)Windows Vista 4)Windows 7 5)Microsoft Word 2007 6)Microsoft Excel 2007 7)Microsoft Power …

    • It looks like a fraud to me. They have a facebook page. At the very top of that page, they have a sentence in text-speak , namely "IF U HAVE BIG DREAMS IN U THEN WE HAVE A BIG OPPORTUNITY TO ACHIEVE ALL UR BIG DREAMS ,IF U WANT TO BE VERY SUCCESSFUL IN THIS AGE & WANT TO BE SELF INDIPENDENT JUST LIKE THE PAGE AND CALL ON :07207412030 for a company that claims to be all about education, this is absolutely ridiculous. They couldn …