How to do a Word Mail Merge with Microsoft Access





How To

News Letters


About Us


How to do a Word Mail Merge with Microsoft Access.

This section covers the how to create labels with an Access database. It uses Office 2002 so for people with office 97, the images may be different but the general procedure is the same.

0) Open up Word 1) Select tools from the Menu. 2) Select Letters and Mailings and slide your mouse over to Mail Merge Wizard... 3) Click on Mail Merge wizard...

We want to use the Mail Merge Wizard as opposed to the Envelopes and Labels because it allows us to hook up a database. Envelopes and Labels only prints one at a time

The Mail Merge side bar opens and asks us What type of document we are working on. 4) Check Labels. You could do envelopes if you wanted but I have found that printing envelopes doesn't work well because the flap you lick and seal the letter is so much of a ridge, it distorts the printing. Creating form letters is easy as you usually only have to put in a name.

At the bottom of the sidebar is a place to move on. 5) Click Next: Starting document

On this step, you should have the labels to hand that you are going to use for your envelopes. You'll the need them so as to get the product information. 6) Click Label options...

7) Select the type of Printer you have. 8) Select how your labels are fed into the pinter. 9) Select the type of labels you are using. 10) Select the product of the labels which is written on the label package. 11) Click OK

12) Click Next: Select recipients

Now we are going to find the database that you want to use for the labels. 13) Click Browse...

Find the database that you are going to use for the mail merge. In this example the database is called database.mdb and is located on the desktop. 14) Click OK.

15) Select the MailMerge table. This table was created in the How to How to create a data source from two Access tables. 16) Click OK

All the recipients should be listed. You can look through the list and uncheck anyone you don't want. You can sort the fields of any column by selecting the down arrow beside the column title. 17) Click OK

The words <> appears on each label - except for the first one.

18) Click Next: Arrange your labels

Before you do step 19, ensure that the cursor is in the first blank label - the one without the <> in it. 19) Select Address block...

20) Select a format of how you want the name to appear. 21) If there is no company name then uncheck this box. 22) Leave this box checked 23) If your labels have foreign countries in them, then check Always include the country/region in the address. The Match Fields Button is useful to ensure that the data is matched up correctly with the data in the Mail Merge Table. It will also show you other fields that you could have used in the labels. 24) Click OK.

The word <> now appears in the first label.

We now want to copy the layout of the first label to the other labels. 25) Click Update all labels.

The label sheet on the screen should now look something like this.

26) Click Next: Preview your labels

The label sheet on the screen will now have changed to something like this.

27) Click Next: Complete the merge

Have your label sheets ready to hand. 28) Click Print...

That's it! Questions or Comments? Contact Us Troubleshooting: If this procedure didn't work for you, check over your Access database and ensure the fields have data in them or that they have the correct data.

Navigation Home

A Little Bit About Us Software

Recent Work...

Cornerstone Software began as a computer programming company in 1998. After completing

Website Design

How To



Search Engine

Contact Us

Software offers web design and software

Tech Support

About Us


several programs that worked with web servers, its expansion lead to both software development and web site design. Today, Cornerstone development in numerous languages and

© Copyright Cornerstone Software 2010 Burnaby, BC, V5J 2L4 Phone: 778-688-9943 All rights reserved.


How to do a Word Mail Merge with Microsoft Access

Home Services Software How To News Letters Blog About Us Contact How to do a Word Mail Merge with Microsoft Access. This section covers the h...

669KB Sizes 2 Downloads 15 Views

Recommend Documents

How to Create a Mail Merge Document Using Microsoft Word
Sep 8, 2011 - Mail Merge mass produces letters, mailing labels or other documents. To perform a mail merge you need two

Microsoft Word Mail Merge -
It will then be used to create a form letter and labels for each name in the data file. Create a Data File in Excel · Cr

Performing a Mail Merge in Microsoft Word
Performing a mail merge in Microsoft Word involves four steps: Creating the Main Document. Creating the Data Source in M

Mail Merge (Microsoft Word) - Word Tips - Tips.Net
Word has a Mail Merge manager that makes putting individualized data into your document easy. The following articles exp

How to Use Mail Merge in Microsoft Word |
When you click on that, 'Start Mail Merge' is the third option from the left side of your screen. After clicking that, y

How to Mail Merge Pictures: INCLUDEPICTURE in Microsoft MS Word
Article: How to use MS Microsoft Word's INCLUDEPICTURE field to mail merge variable signatures, images, photos, pictures

How to do a a mail merge in Microsoft Word 2013 - SimonSezIT
Word provides a Mailings Tab which contains numerous groups and commands useful in Mail Merge, such as the Create, Write

How to Use Mail Merge in Microsoft Word | Webucator
In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge

Word How-to: Mail Merge Setup | Symplebyte
Jun 23, 2006 - Invitations and thank you cards went out using the same mail merge, from Excel to the label sheets using

How to Do a Mail Merge in Microsoft Word - BetterCloud Monitor
Mar 24, 2016 - In Word, select the Mailings tab. From the Start Mail Merge Button, select Step-by-Step Mail Merge Wizard