eHow launches Android app: Get the best of eHow on the go.
Creating Mail Merges with Microsoft Word & Excel
Creating a Mail Merge Document in MS Word
Entering Data Lists to Mail Merge Documents
Matching Data Fields for a Mail Merge
Inserting Mail Merge Fields in Microsoft Word: Part 1
Inserting Mail Merge Fields in Microsoft Word: Part 2
Previewing a Mail Merge Letter
Merging Data Records for a Mail Merge
Creating a New Document in Open Office
Configuring the Address Block for a Mail Merge
Creating a Salutation for an Open Office Mail Merge Document
Inserting Mail Merge Fields in Open Office
Checking a Mail Merge Document in Open Office
Saving & Printing an Open Office Mail Merge Document
Parameters for Saving a Mail Merge Document in Open Office
Creating Mailing Labels in Mail Merge: Part 1
Creating Mailing Labels in Mail Merge: Part 2
Adjusting Mailing Label Settings
Summary: How to know which files will be used for a mail merge; learn more about mail merge features in Microsoft Word, Excel, and Open Office in this free instructional video.
"Hi! I'm Gary for Expert Village. When doing a mail merge, there is three files that are involved. The first one is our main document. Now this is a sample letter that I created and this is the body of the document where we want to put in our data information the fields that we are going to select. I call this a sample letter and in here you can see here in red the fields we are going to merge, we are going to put information. Information is going to come from a second file which is our data base file. Here I created my data base in excel and my data base consists of last names, first names and addresses and city and also because in my letter I have a donation amount and this is my sample data file. The third file is going to be a combination of the two. It is going to be my actual letter with the fields with the data put into the fields. So here you can see my letter now, I call it sample merge sample letters. You can see now that my letter has all the names and information in it. You see the name Mr. Marks. You can see the city and the amounts. Here with have Mr. Solomon lives in Hyde Park with a $100. All that information came from my data base file and each one is different. So I don't have to create this letter so many times. I just created it once and put in my information and this file is separate from my main file. "
eHow Article: Creating Mail Merges with Microsoft Word & Excel
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
Comments
norasahinyan said
on 8/2/2008 Thank you soooo much for this valuable information, i was just going crazy how to do it, i looked at microsoft's page they are not explaining anything,thanks for you time Gary.