essentialsbrazerzkidai.blogg.se

Word 2007 mail merge from excel
Word 2007 mail merge from excel










The Envelope Options multi page dialog box opens. The task pane changes focus is on the Envelope Options link.Press TAB to move to the link in the task pane – Next: Starting Document, and then activate it by pressing ENTER.Other choices include E-mail messages, Envelopes, Labels, and Directory. Mail merge opens in the task pane on the right side of the screen, focus is on Letters radio button. For this exercise, choose Step by Step Mail Merge, W.Start Mail Merge is the first item in that group.

word 2007 mail merge from excel

If you are using the virtual ribbon menu feature in JAWS, DOWN ARROW to the Start Mail Merge group of the lower ribbon. A menu opens with several choices, including Letters, E-mail messages, Envelopes, and more. Press S to activate the Start Mail Merge button.Go to the Mailings tab of the ribbon by pressing ALT+M.The process of creating a mail merge will overwrite any documents that have information already in them. Make sure you have an empty, blank document before going any further! If you have something important open in Word it would be better to close that document and open a new, blank document by pressing CTRL+N.If you don't already have Word open go ahead and launch it on your computer. EnvelopesĮXERCISE Follow along with the instructor to create envelopes for the contacts in your data file.įirst, I want to create envelopes for everyone in the data file. If you are asked to save any changes to it answer No. The more contacts you have, of course, the more rows you have in the data file.įor now, go ahead and close the Excel document by pressing ALT+F4. The column headers in this spreadsheet include:Įach row contains the person's name and address, listed in the appropriate column. Also, for greater flexibility, make sure you use a separate column for first name and last name, as well as middle initial (if desired). Notice that this spreadsheet has column titles at the top of each column.

word 2007 mail merge from excel

In addition, you can just create a new data source by typing a new list.ĮXERCISE: Open the file Contacts.xlsx along with the instructor and explore it. The data file can be a spreadsheet, as in the example we will use today, but you can also import contacts from e-mail programs such as Outlook. However, the instructions are exactly the same for Word 2007. NOTE: In this lesson the instructor is using Word 2010. In this lesson we will use a small Excel workbook called Contacts.xlsx. To create a mail merge, you need to link the Word document to a data source or file. In this Webinar you will learn to use the Microsoft 2010 or 2007 mail merge feature to create envelopes and a letter to mail to your contacts. Typing individual envelopes or mailing labels is also very time-consuming. Have you ever had to send the same letter to several different contacts? If so, you know that retyping the letter or even copying and pasting is time-consuming. Microsoft Word Mail Merge with JAWS and MAGic Microsoft Word Mail Merge with JAWS and MAGic












Word 2007 mail merge from excel