Video: Creating Mail Merges with Microsoft Word & Excel

This Season: Tailgating; Tech Know; New Year, New You; Tax Time

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.

Comments

norasahinyan Aug 02, 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.
norasahinyan Aug 02, 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.

Video Transcript

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.

Follow eHow: Follow @eHow

Creating Mail Merges with Microsoft Word & Excel

Comments

Related Ads

Related Articles & Videos