Hello. Hello. Welcome back. In this video, you'll learn how to perform a mail merge. Let's assume you have a letter and you want to send it to numerous people and you wanted properly formatted
By that I mean you want to address their address on the ladder, along with the personalized salutation. What you could do is create a louder. You can then copy and paste
Their address and their name into the latter save it printed copy and paste. Another address
Print it and repeat that process over and over her Microsoft Word can really simplify this process by using the technique called mail merge.
Using this approach you create one document containing the text and another document contains the contact information that case will be using Microsoft Excel Microsoft Word, they can automatically merge the contact information for Microsoft Excel into
The Microsoft Word document. Okay, let's get started here. I'm going to save a little time just
I just want to, I would give you this Microsoft Excel file. And I want to make sure that you have created so they can actually see your own information there.
So the very first step, you'd want to do is to come along and pressing the start icon and open up Microsoft Excel.
And type that information as shown right here. I'm going to go ahead and you would really need to add first name, last name, title, maybe just a couple of couple times a couple contact information. You can put your name and your
Email address
Sasha.
Oklahoma.
Yeah. You can also do a mail merge on email addresses. So let's go ahead and put one in here.
So in this case, we're going to be focusing more on printed document and if you wanted to. You can actually take this letter and send it out.
All of these addresses. So maybe you've got a business, a church some organization.
And you've got a weekly newsletter a monthly newsletter and you want to send it out. And that's what this year video is all about.
So the very first step you want to do is open up Microsoft Excel and crave your contact information. And again, just to save a little time here. I'm going to go ahead and
I've already had this phone with the first three lines and I'm just going to go ahead and press Save. Now I'm actually going to save this. You may want to save it to your junk drawer URL. Dr. Similar to
The desktop and a folder called a tap. Okay, so we've got our contact information. We're now ready to start the mail merge. But to do that, I'm going to press on the Start icon will open up Microsoft Word.
And I choose a blank document.
Okay, at this point, I'm going to come up here to the maintenance. I'm going to go ahead and we're just be doing start mail merge. I'm going to do a letter and also do envelopes, etc.
The second one thing I need to do is tell where to get that contact information. We're going to use an existing list. And I want to go to can I'm doing it on a desktop.
Maybe pictures on your jumped rocks that are there for called a tab and here it is. Mail Merge addresses and an open
Okay. Soon as you do your and get a little dialog box just hit okay. And we're now ready to get going. So the first thing I'm gonna do is start inserting some information and this information is coming right off the top of this, this first line first name, last name, except for them.
Okay, so I'm going to come along and insert their title the hit the spacebar insert their first name spacebar and the last one, number hit the enter key and Morgan insert their address to therapy. Again, I'm going to insert city karma space.
state space in zip okay the concert, the salutation can hear already since their last name, and you may want to put a colon or semi colon colon or comments in there. And now, if I can. I'm not concerned at all about the water, but let me just grab some text here.
And you can just add one sentences would be fine and more convinced that are more where that you can understand how to do the mail merge. So I'll just
Copy and paste syntax. One thing I've looked in years. So right now that this is kind of double spaced typically the address is going to be single spaced some press on the Home tab come up here to a line spacing line spacing options. Now I'm gonna go zero after and single and press okay
Okay, we're ready to check it out. I'm going to go ahead and press on mailings and I can hit preview results.
So taking a look here at my Microsoft Excel spreadsheet. The first person was Dr. Sue Adams seven 171 Grand Avenue.
And that information is right there. So I could literally just print this out. I can now take a look at the next one. Mr. Bob Baker and there is that person's contact information.
And find mine. I've got one last one. And that's me, right here. So what I can do is, again, the white is you've got the contact information in one pound maybe Microsoft Excel.
And then going to go into Microsoft Word and create my mail in the mail merge document, at which point you can see how easy it is. I could just sit in print print and print, but you can also even simplify this more by coming right up here in what could go
Even just to print documents in we could go from one to three and hit open
And I'm not going to print it and it will literally just print out all three documents. I won't have to step through it one by one.
Well hopefully in this video. Learn how to perform a mail merge. And again, the big trick here is we're going to enter the contact information in Microsoft Excel. Make sure you have this, get your name in there.
Then we're going to come into Microsoft Word and create the mail merge and at that point with music go from one letter to the next one kiss the next video. Thank you.