Printing from Excel

[ShooterDK]

I have taken over as membership director for our gun club. We're into renewals at the moment and to speed up the process I would like to be able to print the envelopes with the members name\address from the spreadsheet.

Has anyone done this?

[Peter.Steele]

https://support.office.com/en-nz/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

[glockman19]

I have taken over as membership director for our gun club. We're into renewals at the moment and to speed up the process I would like to be able to print the envelopes with the members name\address from the spreadsheet.

Has anyone done this?

Try this:

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.

or this:


Print labels

Creating labels with mail merge is a four-step process: set up a document to match your labels, connect to your spreadsheet, format the merge fields, and then print your labels.
Step 1: Set up a document to match your labels
1.On the Mailings tab, click Start Mail Merge > Labels.


2.In the Label Options dialog box, next to Label products, select the company that made your labels.


3. Under Product number, select the product number for your labels.

Tip If none of the options match your labels, click New Label, enter your label's information, and give it a name. Click OK to add the new label to the Product number list.


4.Click OK.

Step 2: Connect to your spreadsheet
1.On the Mailings tab, click Select Recipients > Use an Existing list.


2. Browse to the file you want to use and click Open.


3. In the Open Workbook dialog box, select the sheet you want to use, and leave Cell Range blank to use the entire worksheet or enter a cell range for the data you want to use, and then click OK.


4.In the Edit Labels dialog box, click Insert Merge Field and select the field you want to show on your labels.

Continue adding fields until you've added all the information you want on the labels, and then click OK.

Tip To sort your recipient list or remove recipients, on the Mailings tab, click Filter Recipients, and then click Sort Records or Filter Records. When you're done, click OK.

Step 3: Format the merge fields
1.Format the fields in the first label so it looks the way you want the rest of your labels to look. For example, include a space between First and Last name fields and press Return to start a new line for the Address field.


2. On the Mailings tab, click Update Labels to apply the formatting to all of your labels.

Step 4: Preview and print the labels
1.On the Mailings tab, click Preview Results to see how the labels will look.

Tip Click Preview Results again to view, add, or remove fields.


2.To make additional formatting change, format the first label, and then, on the Mailings tab, click Update labels.


3.On the Mailings tab, click Finish & Merge > Print Documents to complete the mail merge.

Tip If you want to review and update each label individually before printing, on the Mailings tab, click Edit Individual Documents. When you're done, click File > Print to print the labels.



Print envelopes

Printing envelopes with mail merge is a four-step process: set up a document to match your envelopes, connect to your spreadsheet, add and format merge fields, and then print the envelopes.
Step 1: Set up a document to match your envelopes
1.On the Mailings tab, click Start Mail Merge > Envelopes.


2.In the Envelope dialog box, leave the Delivery Address blank and under Return Address, do one of the following:

##Check Use my address to use your address from your email contact list.


##Check Omit to leave the return address blank.


##Uncheck both boxes (Use my address and Omit) and type the return address you want to use.


## Format the Return Address: click Font or Position and make the changes you want.



3. In the Envelope dialog box, under Printing Options, click Page Setup.


4.In the Page Setup dialog box, in the Paper Size list, select the option that matches the size of your envelopes.

Tip If none of the options matches your envelope's size, at the bottom of the Paper Size list, click Manage Custom Sizes. Click the + to add a new list item. In the box, double-click Untitled and then type a name for your envelope. Enter your envelope's dimensions in the Width and Height boxes, and then click OK.


5.In the Page Setup dialog box, next to Orientation, click Landscape, and then click OK.


6.In the Envelope dialog box, click OK.

Step 2: Connect to your spreadsheet
1.On the Mailings tab, click Select Recipients > Use an Existing list.


2. Browse to the file you want to use and click Open.


3. In the Open Workbook dialog box, select the sheet you want to use, and leave Cell Range blank to use the entire worksheet or enter a cell range for the data you want to use and click OK.

Step 3: Add and format merge fields
1.In your document, click in the Drag fields into this box or type text box, and then click the text to remove it.


2.On the Mailings tab, click Insert Merge Field, and click the field you want to add.

Continue adding fields until you have all the information you want on the envelopes.


3.Format the fields in the envelope so it looks the way you want the rest of your envelopes to look. For example, include a space between First and Last name fields and press Return to start a new line for the Address field.

Tip To sort your recipient list or remove recipients, on the Mailings tab, click Filter Recipients, and then click Sort Records or Filter Records. When you're done, click OK.

Step 4: Preview and print the envelopes
1.Click Preview Results to see what the envelopes will look like when you print them. Use the left and right arrows on the Mailings tab, to scroll through each envelope.

Tip Click Preview Results again to view, add, or remove fields.


2.On the Mailings tab, click Finish & Merge > Print Documents to print the envelopes.

Tip If you want to review and update each envelope individually, on the Mailings tab, click Finish & Merge > Edit Individual Documents. When you're finished, click File > Print in each document to print the envelopes.

[ShooterDK]

Thanks Peter and Glockman.