1 / 9

Making a Table in Excel and Mail Merging it to a Word Document

Making a Table in Excel and Mail Merging it to a Word Document. By Maira Engelhardt. Making a Table in Excel. Excel is part of Microsoft Office 2007 Open up Excel and fill in the cells with the needed information These are to be filled out just as a table in Microsoft Word.

palmer
Download Presentation

Making a Table in Excel and Mail Merging it to a Word Document

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Making a Table in Excel and Mail Merging it to a Word Document By MairaEngelhardt

  2. Making a Table in Excel • Excel is part of Microsoft Office 2007 • Open up Excel and fill in the cells with the needed information • These are to be filled out just as a table in Microsoft Word

  3. Continuation of Making a Table in Excel • Here is a video to help with creating a table in excel… • http://www.youtube.com/watch?v=RVZ7VKIN-vk • And here’s another! • http://www.youtube.com/watch?v=XvkpGPjEgQI&NR=1

  4. Continuation of Making a Table in Excel You can center your text using this, located on the home tab --> In order to make the columns wider/narrower or longer/shorter, go to the gray area (between the letters or above cell 1 or numbers next to column A) until you get a bold line with two arrows coming out of it and drag either left, right, up, or down. You can insert or delete columns using these, also located on the home tab

  5. Mail Merge • Save and close the excel document • Open up Microsoft Office 2007 • Click on the “Mailings” tab • Click on located on the mailings tab • Click “letters” • Don’t worry if nothing happens; there will be no apparent change.

  6. Mail Merge • Next, click on • Then, click on “use existing list” • Open up the saved Excel document • Make sure the page with the information on it is selected, most likely the first page of the Excel document • Finally, select

  7. Mail Merge • Select the fields you want to use • When finished, preview the results • When everything looks all right, finish and merge • Edit individual documents

  8. Congratulations! The table in excel has successfully been mail merged into a document! For any further questions, use youtube.com or google.com

More Related