Use a table or query as a mail-merge data source
You can create a mail merge operation by using the Microsoft Word Mail Merge Wizard. This wizard is also available from Microsoft Office Access 2007, and lets you set up a mail merge process that uses a table or query in an Access database as the data source for form letters, e-mail messages, mailing labels, envelopes, or directories. This topic explains how to start the Mail Merge Wizard from Access and create a direct link between a table or query and a Microsoft Office Word 2007 document. This topic covers the process for writing letters. For step-by-step information about how to set up a mail merge process, see Office Word 2007 Help.

---

Performing Mail Merges Using XML Data in Microsoft Office Access 2003
Create a mail merge programmatically from Access using an external XML data file. In this article, walk through how to call Word programmatically from Access to create documents merging boilerplate text and customized data stored in Access. This article demonstrates how to create programmatically a Word mail merge from Access by using data from an XML file. You did this by using the OpenDataSource method of the MailMerge object. Using an external XML file adds versatility to your mail merge applications.

---

Merge Access data with Word
ou can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data.

---

Creating a Mail Merge from Microsoft Access 2007 Data
Mail merge is a very efficient tool when you need to use data from your databases to create letters, envelopes, labels, etc. Microsoft Access 2007 allows you to do this is two ways: either link to an existent Microsoft Word document or create a new document . In general, you won’t need all the fields in a table and most often you'll be creating a query to use only the name and address of the recipients.

---

Create Form Letters With & Without Mail Merge
In this MS-Access Video tutorial we are going to teaches you Create Form Letters With & Without Mail Merge.

---

Microsoft Access and Microsoft Word
Mail Merge: Mail merging allows you to use data on your database to create letters, labels, envelopes, and other documents that require external data originating from another document.

---

Microsoft Access Tutorials
Microsoft Access Beginners Tutorial including Mail Merge, Labels and VBA Tips & Tricks.

---

Mail Merging Microsoft Access Data with a Word Document
We can use Microsoft Access data as the data source for a Microsoft Word Mail Merge document. The Access data can be used in exactly the way needed to create a personalised letter in Word. Often your database is going to be storing specific types of information; many times this information is going to be related to personal data such as names, addresses and other contact type information. If, for example, your personnel department were wanting to mail out information to each employee, they could print out information showing the employees names and addresses, and then re-key this information into a Microsoft Word document with the text of the letter.

---

Microsoft Access XP
Tables, Query, Forms, Reports, Backing up a database, Creating a Mail Merge (pdf file format, install Acrobat Reader to read this tutorial).

---

Export addresses from Access to Word
You can start the merge operation from either Microsoft Access or Microsoft Word. If you are using Access, you can merge data in one of the two ways described in this article.

---

Using Your Data with Word and Excel
Access is designed to work well with other Microsoft Office programs. You can use Access with these programs to perform very powerful operations with your data. For example, you can use information in your Access tables with documents you have created in Word. Specifically, you can use Access and Word to create a mail merge that places the values stored in an Access table into appropriate locations within a Word form letter. In this way, you can quickly create a custom letter for each of your accounts.

---

How to use addresses from an Access 2002 database to create labels in Word 2002
This article explains how to use the Mail Merge feature in Word to create and print labels using data from an Access database. The article contains instructions using the Customers Table in the Northwinds sample database that is supplied with Access.

---

Producing Output
Access provides several methods of producing output for your data. After you preview your data and adjust the page setup options as necessary, you can send the data directly to a printer. You can print a table, query, form, or report, or portions thereof. You can create a special type of report, mailing labels, and you can merge your data to Microsoft Word. In addition, you can fax or e-mail your data from Access, or publish your Access forms or reports on the Web.

---

MS-Access and E-Mails
It is unlikely that you will use Microsoft Access to send your personal e-mails through Internet, when so many other options are available to you. But, when you need to share information from your Access Application with remotely located users regularly and you are sending printed Reports through conventional mail services then you can seriously think about the e-mail option. If you are connected to a Local Area Network (LAN) you can distribute Reports to the recipients through Intranet Mail Service Applications like Lotus Notes.

---

Merge Records from Two Identical Databases
Several months ago I was asked to create a utility to simplify the process of combining data from identical MS Access databases into one file. Not long after completing that project, someone posted a request to the newsgroup, comp.databases.ms-access, asking for suggestions for doing the same with his data. I replied to his post with an outline of the steps taken to perform my data merge.

---

Set options and send objects in electronic mail from Access
Learn: Add a digital signature to an outgoing message, Add a digital signature to all outgoing messages, Have replies to your message sent to another user, Manually check names before sending a message, Choose which e-mail account to use to send a message, Send a database object's output as an attachment to an e-mail message, Send a data access page as the body of an e-mail message.

---

Merge groups
When you merge two groups on a data access page, Microsoft Access moves the controls in the group header and group footer of the selected group level into the header and footer of the next lower group level.

---

Data Collection E-mail Options
Use the Collecting Data Using E-Mail Options dialog box to view and change the options that control how Microsoft Office Access 2007 processes replies to a data collection e-mail message. The settings apply to all future replies to the e-mail message that is currently selected or being generated.

---

Sending a data access page in e-mail
When you send a data access page in e-mail, there are important connection and security considerations you need to be aware of to ensure more reliable results.

---

Demo: Collect data in Access 2007 by using e-mail
Did you know that you can use e-mail messages to add data to your Access 2007 databases? You begin with the Collect Data Through E-mail Messages Wizard, which guides you through the steps of creating a form. The form is sent through Microsoft Office Outlook 2007 to your recipients, with your request for new or updated information. When the recipients reply to your message, Access automatically enters their data into your database. Watch the demo to see how the wizard can save you time.

---

Microsoft Access - Database
Database software is the most complex, but the most powerful, microcomputer application software. A database is a collection of data which are related. Data are collected, printed, sorted, archived, and displayed. Data can be exported to other applications from a database and data from other applications can be imported into a database. In a database, the data are arranged in tables. We are going to create a database consisting of two simple tables. We will save and print the database. We will then use our database in a mail merge activity using Microsoft Word.

---

Configure Outlook for Lotus Notes
We have seen that sending EMails from MS-Access is easy enough like any other method you are familiar with. With few clicks we can send an email with MS-Access Objects as attachment to the mail. Depending on the object selected for attachment the output format options available may be different. The attachment format for VB Code module is Text format only and will be converted into this format before attaching it to the mail.

---

Manually process data collection replies
When you collect and update data by using e-mail, you use Microsoft Office Access 2007 and Microsoft Office Outlook 2007 to generate and send an e-mail message that includes a data entry form. The recipients of the e-mail then fill out the forms and send them back to you as replies.

---

MailMerge
Objectives: Learn to use MailMerge Step 1 - Create Form Letter, Step 2A - Select Data Source, Step 2B - Insert Merge Fields, Step 3 - Merge

---

Report snapshots and Snapshot Viewer
If you regularly print, photocopy, and mail Access reports to users inside and even outside of your organization, you may want an alternative for distributing these reports that will be more cost-effective. You might prefer to send reports in e-mail or post them to a Web site for quick and easy access. Further, you may want your users to view these reports in an enhanced format, including color, fonts, charts, and other embedded objects. Finally, you may want all this without your users' needing a full or run-time Access license to view and print Access reports. The combination of creating report snapshots and having your users view them with the Snapshot Viewer should fit all these needs.

---

Collect data by using e-mail messages
Microsoft Office Access 2007 makes it easy to gather data from people who are located anywhere on the globe, such as members of your sales team, survey participants, or contacts. Office Access 2007 works with Microsoft Office Outlook 2007 to help you to generate and send an e-mail message that includes a data entry form. When the recipients fill out the forms and send them back to you, the replies are processed according to your specifications. For example, if you choose to have the replies automatically processed, the contents of the form are added to the appropriate table in your database as soon as the reply reaches your inbox. This new feature, the Collect data through e-mail messages Wizard, can save you hours that you might have otherwise spent entering data on behalf of your users.

---

Distribute a report electronically
You can use Microsoft Office Access to electronically distribute your Access reports. For example, you can use the E-mail command on the Microsoft Office Button menu to quickly export and send the report as an attachment in an e-mail message. Or, you can export the report as a file, and then distribute the file in several different ways. By using electronic distribution methods, you can quickly get important information to those who need it. In addition, you can use the files to create backups and archives of reports, and you can also reduce paper usage in situations where printed copies of reports are not necessary. This article explains the different file formats you can use to export a report, and discusses the different methods you can use to distribute the exported report to your recipients. What do you want to do? * Understand the file formats to which you can export a report * Distribute a report by using the E-mail command * Distribute a report by using other methods

---

Collecting Information for an Access Database by E-mail
Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard designed to facilitate this task. In this tutorial, we walk through the process of populating an Access table with user-provided information.

---

Create a Report Snapshot in Microsoft Access
Report snapshots offer a portable format that can be used to view Access reports on systems that don't have Microsoft Access installed. It's available for most versions of Windows and allows you to share reports via e-mail, the web or automated processes.

---

How to Merge Records from Two Identical Access Databases
The process of merging relational data can get quite complicated, especially when you have numerous core-data tables as well as lookup tables. Danny Lesandrini explains the basic steps.

---

Create mailing labels in Access
Microsoft Office Access 2007 gives you several different options for creating labels containing data stored in your Access tables. The simplest is to use the Label Wizard in Access to create and print your labels from a report you create. In addition, you can import data into Access from other sources, such as Microsoft Office Excel 2007 workbooks and Microsoft Office Outlook 2007 contact lists and "merge" that data or existing Access tables with a Microsoft Office Word 2007 document and then create and print labels from Word.

---

Automated E-Mail Alerts
Learn how to send email alert automatically by using Access.

---

SendObject Macro Action
You can use the SendObject action to include the specified Microsoft Office Access 2007 datasheet, form, report, module, or data access page in an electronic mail message, where it can be viewed and forwarded.

---

Create an Update Action Query
Microsoft Access 2003 lets you create an append action query to merge tables at the end of one or more existing tables. Appending tables saves you the effort of retyping data. Follow these steps to create an append action query in Access 2003.

---

Database Maintenance, Import, and Export
Data entry consists of typing values in data fields or selecting values from bound controls. Some records happen to have the same value for a particular field, or most records hold a common value for a certain field. When designing a form, you can assign the most commonly used value to such a field so the user would not have to type it. The user would change the value only if it is different from the usual. For example, when creating a database for a small company, all employees may have the same telephone number but with individual extensions. When a new record is being entered, the value would be set already for the field. Topics covered: Data Maintenance, Data Import/Export, Saving a Database Object As a Web Page, Mail Merge, Considerations on Data Entry, Maintenance of Imported Objects and Database Backup

---

Create a Select Query
You can retrieve and display specific database records by creating a select query in Microsoft Access. For example, you could create a query to display the names and e-mail addresses from your Address table. These instructions apply to Access 97.

---

Create a picture or command button that works as a hyperlink
You can use a picture as a hyperlink on a form, report, or data access page. Although hyperlinks in a report won't work when viewed in Microsoft Access, the hyperlinks will work when you output the report to Microsoft Word, to Microsoft Excel, or to HTML. By using a picture: Create a hyperlink to an existing file or Web page. Create a new data access page and a picture that's a hyperlink to that page. Create a hyperlink between two data access pages. Create a hyperlink to an object in the current database. Create a picture that creates an e-mail message when clicked. By using a command button: Create a hyperlink to an existing file or Web page. Create a new data access page and a command button that's a hyperlink to that page. Create a hyperlink to an object in the current database. Create a command button that creates an e-mail message when clicked.

---

Collect data by using e-mail messages in Microsoft Access 2007
This tutorial deals with a new feature introduced to Access 2007. Until now the possibility to retrieve information into your Access data base from infrequent users who are not connected to you application was limited to several options. So far the easiest way 'but also quite long' was to explore the data base as Excel file and then send it as attachment to the persons who needed to fill the information and when you get the info, someone would have to put it in the data base...long process not to mention that a lot of errors might occur

---

Custom Command Bar Button
Access database developers often customize their applications to make the applications more efficient and more useful for their users. Creating a custom button on a command bar for time-consuming, repetitive tasks can be a real time saver. For example, the user may want to automate e-mailing a report to all managers in an organization. Instead of manually opening the report, saving it as a Snapshot file, creating a new e-mail and assigning the list of recipients, then attaching the Snapshot file and sending the e-mail to those recipients, the user can just click on a custom button on the command bar, and all of these steps will automatically be executed.

---

Access 2007 Reports Tutorials for beginners
Reports summarize and present data stored on tables. A report can be executed at any time and it will always reflect the updated data of the data base. The information usually has a format that allows printing, but it's possible to be consulted in the screen, to be exported to another program or also to be sent by electronic mail. You can create a wide variety of reports in Microsoft Office Access 2007, from simplest to most complex.

---