How to print addresses on envelops directly from excel?
So, you want to send out a bunch of
invitations. And you want it to look professional. But, wondering; “Can I
directly print on envelopes from excel; I have all my data on excel?” Well!! Sure you can. Follow the steps below
and you will be good to go:
Step 1: Make sure your data in excel is
arranged under two separate columns- Name & address.
Step 2: Open Word
Step 3: Go to the tab “MAILINGS” and choose
“START MAIL MERGE”
Step 4: You will see a down arrow on “START
MAIL MERGE”, click on it and choose “ENVELOPE”. A pop up window will appear
Step 5: Select the desired envelope size
from the drop down menu. By default it is 10. Click “OK”
Step 6: Now go to “SELECT RECIPIENTS” which
is just beside the “start mail merge” button. Click on the down arrow and
select “USE AN EXISTING LIST…”
Step 7: A window opens up which will prompt
you to locate the excel file that you created in STEP 1. Select the file and
click “OPEN”. If you have more than a sheet in your workbook, excel will
further prompt you to select the particular sheet. As soon as you open your
excel file, a set of other buttons are activated which falls to the right of
“select recipients” option.
Step 8: These newly activated buttons are
under “write and insert fields”. This is where you pull data from your excel
onto your current document and can edit it as you desire. Click on “INSERT
MERGE FIELD”.
Step 9: From the drop down menu select
“NAMES”. Press enter and again from the same drop down menu select “ADDRESS”.
Now you have already included all the name and address filed which is to go on
to the envelopes. 
Remember to press enter after you have inserted the name
field or else the names and address will print in the same line.It should appear like this: <<NAME>>
<<ADDRESS>>
Step 10: Finally click on “FINISH &
MERGE” and from the drop down menu select “PRINT DOCUMENTS” to print.
The above tutorial explains the process
based on MS Office 2013, however the steps are equally applicable to MS Office
2007 and 2010 versions.
