A learners introduction to Microsoft Word Mail Merge Easy to learn in a few minutes

A learners guide to creating a mail merge using Word and Excel.
You will often be asked in job application tests if you know how to perform this task. This demonstration will show the quickest and easiest way to learn the procedure.
The files used in this lesson demonstration can be downloaded for free for practice.
Just go to http://unitedcomputerconsultants.com/word
Look for two files: "mail merge word" and "mail merge excel"

Visit us at : http://unitedcomputerconsultants.com
Join us at: : http://facebook.com/unitedcomputerconsultants
Tweet us at: http://twitter.com/geoffhudson7

---

Closed Caption:

up
good morning good afternoon or evening
review not pay
in trying to be I have a small excel
file
it's an address book title for Snipes
said I'm
address it's a trap it goes across to
you
the final column which is I UK
some sometimes called a postcard
depending on where you live
now a mile bitch
which is well I'm going to show you to
create he said method is sending
one letter to many different people and
this particular applied is particularly
I aimed at
those people who might be a little newer
two competing
perhaps a learner's BB its epcot and I
can assure you
the easiest way to create a mild bleach
it is something that I
often asked about in my at died today
teaching and trying
and it is a really very very simple when
you follow a couple loads but
straightforward rules
set list so that how we do it here I
have a Word document
ivory prepared the word document its I E
edification
to the a.m. to the next meeting at the
club
on September 30 and to create the
BioBlitz as I can send this letter to
each had two people in the address book
I gonna trip under my Links tab
IPS and then in the stat mile mujhe
group
I said that there's a drop a right next
to stat Mile Beach
let's click on the Dhrupad and then
public to balance it a PIA
to use step-by-step mile merge wizard
but that does on the right hand side
it stops the wizard with the same
resolve demands that you can enter
or take
and the next step is already showered at
the bottom
Saturday it snows what type of document
are you working on well in this case we
gonna be working on lettuce in tonight
we work on letters for a mile mooch
you can see that there are other options
available to me
but this exercise as I say letters
next what is the study document. do I
want to use the car document
this one we're gonna stop me template
for existing document if I picked on
existing document
they don't have to Brandeis to you that
document to
find in this case we use the card
document Picasa just the it is a very
convenient way
to at the document already opened that
you want to use in the Mile Beach
next is some shit selected recipients
now here of another type a new list
if I wish bat we go to use the existing
list
the excel file that we soar at the very
start
so the usual existing list I need to
browse
and the existing list that I want
is on my desktop in disguise
and its it six air her
address book little buddy happy summer
you address book
xlsx I'll double click it and know what
happened
the Select terrible and is asking me
what shade
in the excel file I the addresses of
will rule in Chi Chuan
try to keep them all on the same sheet
when you prepare your own
let's look like a
and see what happens. incidently to
through traffic data entice the column
headers
because I become the field that's quick
I K
and there that now
you notice that there are tix next to
you H name
if I don't want somebody to be on the
Miley list
I simply and take that person in this
price
I want everybody to be on the Miley list
show only to kick in
I could sharply recipient list by
any particular order
but I wish I can show grab but to bring
people out
et cetera find duplicates sometimes
people get it but why should do I yeah
you're buying list in this patient there
I not now it's quick I K
and the next step
it shows right your let up
so I will be kicked click right you left
there are various options here
and I get to show you something here
that is often overlooked
you notice that next to the word DF
I were to put in the first dime all that
the person so I have a spice after the
wood DF but I also don't want to put the
address
above the woody a now this is my very
first lodged at the moment so I've got
to create
sufficient space by pressing the
indicate to create a bright line
and then I choose address block because
what that will do
that will ask me how I want to insert
the recipients to I want them
mister or mister with the bout whatever
might be
that his hair I want them to appear
there and I can also
scroll through to check the next one et
cetera et cetera
so I'm quite happy with things as they
appear
let's click i cud the address prep
school has been entered
now the next hero 108 F is the first
night
and I could do that by Gary to the more
items
and changing this night and then I will
insert
the first night Delco use the associate
merge
to shall pass a good now it's just
next preview letters and
I can again I can check 302 she have a
guy to appeal
and if I wanted to work closely address
said the address is left a bit
when I could do would be to I'm I
select this information here
and I could use it to have cab
the line spacing here to make it
one which would closing up a little bit
but we'll look at that
in the next step now whoops the
next step is to complete the marriage
and
when I complete the marriage are given
the choice have two things he ought to
know the print
the document I can it
individual licence if I click Print
and print where the records I simply
click I K
but I want to you headed individual
letters to show you
down here have i'd never filed
will be created but the moment we had
the fire
the adult topics open when I visited
individual letters
it also gives me the opportunity to
manage to eat you
document and we're ready to do that is
to click OK and watch what happens day
out here in the thais bath
another document
is created which is the only I'm
which which is the look at that we going
to be able to print
to send to everybody because now I can
say
is is the fact that I can if I wish
I can go to you batter print
print preview and now
show your love my levels I will probably
have it added another couple
the blank flaunted the spitting it out a
bit that bad
I can also check featured a live news
media down here in the print preview
scrawl edge to go through and
no thats are quite happy the shoe print
command
then I would do it I rode
innis let hey here if I wanted to keep a
record this letter
when I click click K sound badass
and I gotta put it a
under the desk top so I get really very
next time
and Ocho it a mahler millich club
meeting
because when I do that
if I don't want to print things
immediately what I can do is to college
this follow
I'll close this follows well
ninety decided that one
but when I can add a but said it's the
next vacay
I can fly faster open
mileage club meeting and
they they all laughed and as our page
down I can see olivares
available wanting to be pretty that's
half mile beach
is handled in the simplest applies
little better practice you don't need to
create massive documents to learn
as you sir I and he had progresses and
the
in the address book create your I N well
if you wish
you can download about that the setting
fires the excel in the word file
from the lake that I shall you in the
description belie
thank you so much for watching don't
forget to subscribe to it you've already
done so
and we'll see you next time but for now