4tOPS Mail Merge for Microsoft Access 2010 the ultimate solution if you want to create documents (Word, Excel, PDF) or e-mails using data in your Microsoft Access database. Documents can be created easily with any level of complexity (e.g. contracts). Selectively producing documents is as easy using selecting the records using filters and record selectors. Supports e-mail mail merge, labels and envelopes, directory reports and listings. Mail Merge is one of the main type of uses in any administrative software application. It is used extensively in all industries, typically by Access users that need document creation for their Office business application (quotations, letters, invoices, contracts, reports). Professionals that collect data for engineering, research or other purpose and want to create complex documents from it (surveys, reports, audits,…). Mail Merge for Microsoft Access can be used both by professional Access developers and Access power users.
Mail Merge for Microsoft Access differs from other Mail Merge software on the market: Tightly integrated with Microsoft Access; Easy selection of what record(s) are to be used to create a mail merge from; Supports creation of documents of virtually unlimited complexity; Supports automatic naming and storing of documents based on variables such as field values, template or process names; Many ways to refine mail merge process definition. Extremely user friendly with Mail Merge Wizard, Template Designer and Process Designer Easy deployment of your solution. Even if your organization has implemented strict Security measures this will not prevent you from easily installing and using Access Mail Merge.LEARNING OUTCOMESIn Lesson 6 you were introduced to theAccess 2010database. In Lesson 7 you are going to applywhat you have learned about databases to the task of creating form letters and mailing labels.The process is called Mail Merge and it is an important word processing skill with which everyteacher should be familiar.Microsoft’sOffice 2010is an integrated suite of programs. This means that the differentcomponents of theOfficesoftware—Word,Access,Excel, andPowerPoint,for example—are allpart of the same system. As a result, you can easily switch from one component to another, cutand paste data between documents, and above all use a common set of tools with all theapplications. The steps required to edit, copy, arrange, print, format, cut and paste, and so forth,are more or less the same whether you are in the word processor, database, spreadsheet orpresentation components of MicrosoftOffice.You can merge data from a database into different types ofOfficedocuments to produce anynumber of versions of a standard document tailored to address individual recipients. This isespecially useful when creating form letters, which are another type of template or stationerydocument. But you can also merge data into a spreadsheet (such as an invoice or otheraccounting document) or into a drawing document. You can create mailing labels, or anydocument that requires fill-in-the-blanks data.In this tutorial you will practice these skills by writing a form letter to your students’ homecontact (parents or guardians). A form letter is simply a letter which is to be circulated to a groupof people such as parents, and into which you place data specific to each individual in the group.So a form letter is a personalized circular letter that is customized for each individual whoreceives it.The first of the two letters you are going to develop will inform parents of an upcoming fieldtrip. The second will report on each student’s progress after five weeks of a class session. TheMicrosoftWordmail merge feature greatly simplifies the process of creating form letters of thiskind.In this tutorial, then, you will complete the following tasks:•prepare a data source document (anAccess 2010database) for a form letter;•create the form letter;•prepare a set of field trip notices;•prepare mailing labels;•prepare a new form letter using an existing data source document (anAccess 2010database)