I have an Excel spreadsheet with the grades of my students. Every so often I'd like to email out their current grades, one email per student, that will only include their last three homework grades or so. Ideally I'd use Thunderbird to email it out but that might be trouble. Mail.app could also work, or Outlook in a pinch. I've tried Word's Mail Merge and got all the way to the sixth step but the 'Generate e-mail messages' option there is always greyed out, whatever I seem to be trying. I'd also be happy with another solution, like using LibreOffice or exporting as text and using some command line tool to email it out but so far I haven't been able to emailing anything via mailx. In the end, staying within the Microsoft Office environment is probably the easiest answer.

Schedule a Recurring E-mail If you are sending the same e-mails on a recurring basis like daily, weekly, monthly etc to send for instance a reminder or an update report as attachment you may want to automate that.

Sorry for not having researched that more thoroughly before asking the question. 'Generate e-mail messages' in the last step was greyed out because Microsoft Outlook was not the default email application. So to make it work: • (Temporarily) Make MS Outlook the default email application: This is an option within the Mail.app preferences. • Go through the usual mail merge steps.

Note that the email-address does not need to be in the Word message, but I would recommend to have it as a field in the Excel sheet. Canon ip90v driver for mac sierra. • In the last step the 'generate e-mail messages' option should not be greyed out anymore. • A small window pops open. Among other options (Subject, for example) the field containing the email address can be chosen here. • The format can be chosen as 'Text', 'HTML' and 'Attachment'. When sending as text, all me line breaks would disappear, so I ended up sending as HTML, even though I very much prefer 'text'. Don't forget to undo your choice of default email app, if you normally use another one.).

The Mail Merge function provides the ability to create a personalized document that you will send to multiple recipients. To complete all the steps of the Mail Merge process, you will need both Microsoft Word and Microsoft Outlook 2016. Creating a Mail Merge Complete the following steps to create a Mail Merge.

• Open Microsoft Word. • Open a blank document.

• Select the Mailings tab at the top of the screen. The Mailings toolbar displays. • Select the Start Mail Merge button, located in the Mailings toolbar. A drop-down menu displays.

• From the drop-down menu, select an option. Each option will be similar in process, but will contain individual steps that are specific to that process. For this example, E-mail Messages will be selected.

• Next, select the Select Recipients button. A drop-down menu displays. • There are three (3) ways to select the recipients for your Mail Merge email. You can manually Type a New List, Use an Existing List, or Choose from Outlook Contacts.

The recommended Mail Merge method is to use an Excel spreadsheet. This provides better control of the address information and how that information appears in your email. Create an Excel spreadsheet of the address data before you begin the Mail Merge process.Then, select Use an Existing List from the drop-down menu. A Browse screen displays. • Navigate to the location of your Excel spreadsheet and select the file. Then, select the Open button.

The Select Table screen displays. • The Select Table screen displays the tab name that contains data in the Excel spreadsheet you selected. • Select the First row of data contains column headers checkbox to tell Excel to skip the first row of the spreadsheet because it contains column names, if applicable. Quickbooks 2009 for mac download free. • Select the OK button.

The Select Table screen closes. • In the blank Word document that is displayed, begin typing the email you want to send. If you have already composed this email, you can copy and paste it from another source. • After you have composed the email, you will begin to insert the Mail Merge fields.

This will map the data within your Excel spreadsheet to a location within your email. • Select the Mailings tab, located in the Word toolbar, if it is not still selected. • Next, place your cursor in the location that you want to insert the first Mail Merge field. • Select the Insert Merge Field option. A drop-down menu displays.