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.