To finish the merge, click Finish & Merge, and then click Print Documents or Send E-mail Messages.Ĭreate or delete an Excel table in a worksheet When your document’s ready, click Preview Results and click the arrows to see each specific copy of the document. Or add addresses from your list by clicking Mailings > Address Block. For example, to add a greeting line to an email message or a letter, click Mailings > Greeting Line. Next, you can insert mail merge fields that pull the information from your spreadsheet into your document. Now the Excel spreadsheet’s connected to the mail merge document you’re creating in Word. If Word prompts you, select Sheet1$ and click OK. When the data’s ready, start the mail mergeĬlick Mailings > Start Mail Merge, and then click the kind of merge you want to run.Ĭlick Select Recipients > Use Existing List.īrowse to your Excel spreadsheet, and then click Open. If your spreadsheet includes dates, times, currency values, or postal codes that begin or end in 0, see Format mail merge numbers, dates, and other values. For example, to address readers by their first name, make sure you have separate columns for first and last names.Īll the data you want to merge is in the spreadsheet. The columns in your spreadsheet match the fields you want to use in your merge. The merge runs more smoothly if all the information you want to include is ready-so, make sure: Customize your mail merge with personalized messages. Import lists from Excel, and use Excel's data and number tools. Any messages sent will have the “reply-to” address of the Outlook mailbox profile that is open.Go beyond the mail merge basics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |