Excel Tip: Mail Merge to PowerPoint via Word Outline October 16, 2016 A reader asked how to convert an Excel workbook into a PowerPoint presentation where the first column was a title page and the next two columns were the subtitles. Mail Merge INTO Excel? I have records in an Excel (or Access) file and wish to mail merge those records into a different Excel file so that I may then print out 4300 customized letters. I've seen lots of stuff about mail merging from Excel and have done so many times but I've never seen anything about mail merging into Excel.
![Mail Merge Video From Excel Mail Merge Video From Excel](https://i.ytimg.com/vi/G-pZKyG373s/maxresdefault.jpg)
Doing a mail merge using may get you confused or stuck, not because it is difficult or impossible to do, but because there are specific steps you need to follow. Missing a step, or doing something out of order may give you unwanted results. I would like to help you out and give you step by step instructions, complete with images, on how to do a mail merge and create mailing labels using. I will also go over how to add a return address to your labels. Let's get started! Address Labels 1.
To start the mail merge for labels, you should have a list of all the addresses. I put all my addresses in an Excel spreadsheet with specific columns for first, middle, and last name, address, city, state, and zip code, saving all 3,000 of my addresses to my desktop with the name of “3000 names.xlsx”. You can see a screenshot of my Excel spreadsheet below. Now let's open up Word 2010 and click on the Mailing tab all the way on top. Enounce myspeed crack. Click on Start Mail Merge and then select Labels. Please don't worry if your window looks a little different and you have bigger icons on your toolbar.
My Word 2010 window was resized and was not maximized so it was only trying to fit as many options as possible in the space I was allowing. Once you click on Labels, a Label Options window opens. Go ahead and select the Label vendors. In my example I am going to go with the popular Avery US Letter.
Then select the labels you want. I am going to use 8662 Easy Peel Address Labels as I still have a lot of them left from when I did the merge in Office 2007. Once you are happy with your selection, click OK. After you hit OK, click on Select Recipients and then select Use Existing List. We are going to use that list I mentioned in step 1. Point to the location where the excel spreadsheet is located.
As you can see, my list is on a desktop in a folder called Addresses. Select your spreadsheet and click on Open. Select the appropriate Table – in my example it is the one called 3000$. If you did not rename your table it is probably just called Sheet1$ - so select that one. Please check the check mark next to the first row of data that contains column headers.
You should have column headers otherwise you will only see A, B, C, etc. And it will be very difficult for you to figure out which column is the first name and which one is the zip code. Once you make the table selection and you check the box, click on OK.
![Label mail merge from excel video Label mail merge from excel video](https://i.ytimg.com/vi/rztEs-GzQmI/maxresdefault.jpg)
After you click OK, your Word 2010 document should look like this. You should see each separate label. There are two ways of adding the addresses to our labels: a. The first one is to click on the Address Block i. When you select the Address Block, you need to make sure the format is what you want and that all the fields you want are included. In the example below we select the format with the middle initial, but when we scroll down to record 4, for Lisa, we notice that her apartment number is not listed. In order to include it, we need to manually match fields.