now I'm going to show you a quick and easy way to make mailing labels
added your access to data I'm now some %uh views the mail merge two more and
Microsoft Word
I which is great back to use access to
we can actually make my own labels right from access
so let's say we have I just came over here are we have the other customers to
bomb
tried and of course we have the customer are the new company name and the address
and everything like that
well we like to make not nice labels from there so watch are usually we can
do that we're gonna pick on
other create menu now what you wanna do
is you pick users click on your team of our first
membership you pick the ball from which he won a major labels
first then you click on Create and if you know service you have this one is
called
labels okay the first thing that you got a pic
major label size now the ones and I'm familiar with would be the euthanasia
because and lush
the label type usually is going to be she peed
if you have a LaserJet primera vez jet trainers going to be sheepskin
now if you have one of those printers and have I you know the
that the paper that rolls up then there would be continuous cute
but you don't really see those too much anymore however I i've seen companies
are still have those the printer labels because they have so many label so
that stock could be a possibility but alive is in this year's initiated
now the one saddam ok familiar with her oversee our Cisco come by manufacturer
the click on that pole down I'll
quite frankly the only ones have actually use our injuries labels and
these these are just different manufacturers are labels but
your name as you can purchase Office Max or staples
I and those are really popular so this company free
and then up here is going to show you all the free product numbers
so you know you can go to Office Max or staples
and you know they would they would solve a lot of the some sure
now are really popular one is called 5116
and 5160 is your standard address label so on this guy
you stop by anyone have the should work just fine so what pic on next
now I hear is ask you for the fine
and the font size in the color of the label I don't use the change that's here
because I don't even know what the label looks like yet
we could she's got here but there are the habit while another opportunity
change that later on site uses a script that scream
I wanna come next okay
now in this Keenan wants to build a prototype label imagine what your car is
hit by a bus car look like
on the first time it happened the mix the second myron have to address
and answer my we have the city stands up you know just as an example
so you can use your fields to bill your prototype label
on the first line I'm a Democrat from the company name and knows how that
wound up in my prototype label
to go to the next line and this may hit the Enter key on the keyboard
or I can just click on the second line either way is fine where use the address
on the second line so I double click on that
on a click on the third line at the label
and on the farm on oMG I double click on the city now between the city and the
state I'm gonna have a comma
and its space so I just tried to them I've never stayed here is called region
cuz some other international so I double click on a region
and then I'll have another space between bad and the postal code
and I double click on postal code so you're very welcome in any combination
of yours year olds
and then when you wanna get next time you just click on the next line
we can also type information in there as well ok act so
let's say let's say I in this case will pick on next
the screen as ask you if you like the Super
your labels and that's everything is sorted by
I am by country and then by postal code within
II country cuz a it least here in the United States
if you have your mail sorted by the postal code if you have enough now
bring that down to the post office Jamaica above a discount because the
sort by postal code so we'll be there
serve my country my personal coach will take on next
and now we're done with the Razorbacks ms pecan finish
but with this wizard
every time I run as I always get this mass as it is just a warning
I so you don't really have to worry about just click on OK
and just like that in less than five minutes
we were able to build labels out of our customer stable
and all three dead that was our the label was as soon as hell Trinity at the
you know the company
address the city I'll
a and more in this case I just had this I'm
a second line address but and overlapped are you have them and the company
the address the city now so I'll know how to reach you cuz its international
but this has a region as you can said
and then has to post a car so just like that M
less than a couple man's we were able to i believe i males use the label was a
if you train in fact that would fit perfectly
on that label size that read shares which in this case was the
I the 5160 when a close that window
and now we have beautiful labels if I scroll down
you gonna see this is there a report that I made in a previous example and
then here's the labels
they were just here by the way when we change that
the ball then the reports get up there automatically
and as a matter of fact only change to table the queerness
get up there on a Mac rating so that the forms I think I come from the table
but thats a quick and easy way to make labels using Microsoft Access
the label wizard
