Episode Synopsis "Mail Merge E-mail Messages"

Mail Merge E-mail MessagesWindows and Mac Mail merge has been around for a while, but I don't like to waste the money on printing and mailing. With Microsoft Office, I can create an e-mail merge to save on time and money. For this example, I'll be using Word for my letter, Excel for my list and Outlook to send the email. In Microsoft Word, you can use an existing letter or type a new one from scratch. I already have a letter I'd like to repurpose for this message.1.       In Windows, click the Mailings tab.On the Mac, go to the Tools menu and select Mail Merge Manager.2.       In Windows, click Start Mail Merge and select E-mail Message.On the Mac in the Mail Merge Manager, click Create New and select Form Letters.3.       Click on Select Recipients and select Use Existing List.On the Mac in the Mail Merge Manager, select Get List and Open Data Source...4.       Navigate to find your list. When using Excel, you'll be asked to select which worksheet to use.5.       In Windows, select the fields to replace and click the words Insert Merge Field and select the name of the field to insert.On the Mac, from the Mail Merge Manager, simply drag and drop the field to its proper location.6.       Click to Preview Results (View Merged Data on the Mac) and double check everything is okay.7.       Use the record selector to double-check to be sure everything is in the proper location.8.       When satisfied, go to Finish & Merge and Send E-mail Messages.On the Mac, select Generate e-mail messages in the Mail Merge Manager.9.       Select the field which contains the e-mail address.Type the Subject line you'd like to appear on the e-mail message, and then click OK (Mail Merge to Outlook on the Mac). Back in Outlook, in the Sent Items folder, you'll find all the e-mails that have been sent.

Listen "Mail Merge E-mail Messages"

More episodes of the podcast UNL Office 365 channel

• View the Created Date in Drafts
• Editing default sounds in Outlook
• Saving drafts
• Downloading images from trusted senders
• Mail Merge E-mail Messages
• Make an appointment from a message
• My Day - For Mac users
• Contacts: Folders & Folder Groups
• Scheduling assistant
• Use Message Templates
• 2 day calendar view
• Color-code incoming messages
• Attach your calendar
• Create a standard response
• Set a calendar reminder
• Editing received messages in Outlook
• Contacts tips
• Creating a Contact Group from an Excel list
• Calendar Trick- Reoccuring event
• Calendar Basics
• Preview button
• Scrapbook
• Out of Office settings
• Outlook search tools
• Setting calendar permissions