Creating Mail Merges with Microsoft Word & Excel

"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."