![]() ![]() In the first course, we created a list from our Outlook contacts and then created one from scratch in Word.īut you can also import lists from other sources, like Microsoft Excel files. In Introduction to Mail Merge you learned the basics: how to set up mail merge with the wizard, create a list of recipients, add basic mail merge fields, and print envelopes.įirst let's take a look at recipient lists. 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. Make sure you choose Treat as an alias.Go beyond the mail merge basics. Enter your name and Outlook email address and click Next Step. You can now add your Outlook account as an alias in Gmail. Switch to the Accounts tab and choose Add another email address under the Send mail as section. Go to your Gmail account and choose Settings from the gear icon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |