Monday, January 17, 2011

How to Print Envelopes From Data in Excel


1. Format your information in Excel with column headers. For example, write 'name' in cell 'A1' as a column header and then list the recipient names in column A starting at cell A2. Write 'address' in cell B1 and then list the recipient addresses below that in column B.
2. Open Microsoft Word.
3. Start the Mail Merge wizard in Word 2007 by clicking on the 'Mailings' tab and clicking on the down arrow to the right of 'Mail Merge.' Click on 'Mail Merge Wizard.' In Word 2003, you can start the Mail Merge Wizard by clicking on 'Tools->Letters and Mailings->Mail Merge.'
4. Choose 'Envelopes' from the list box. A pop-up window will appear.
5. Choose the envelope size from the 'Envelope size' drop-down box. For example, choose 'Size 10' envelope. Press 'OK.'
6. Click on 'Select Recipients' from the toolbar, then choose 'Use existing list.'
7. Find the Excel file on your computer, then press 'Open.' If you have multiple sheets in your workbook, Excel may ask you to select the worksheet. If that happens, click on the worksheet and click 'OK.'
8. Click on 'Insert Merge Field' on the toolbar. This is where you tell Excel to put the information. Excel will have pulled the fields from your Excel data. For example, you may have a 'name' field (select it from the list).
9. Click on 'Finish and Merge.' Choose 'Print' from the list of options to print your envelopes.

Blogger news