So this probably seems like a rather random topic for the blog but given I do write a lot about being organised, I felt this (sort of) fitted the bill. It’s something I have been struggling to work out for the last week and I couldn’t find a good guide anywhere so decided to write my own. After many moments of frustration and endless Google searching on guides for how to do a mail merge email with office for Mac I’ve finally worked it out!!

Step by step guide on how to do a mail merge email with office for Mac

For more info, see Prepare your data source in Excel for a mail merge in Word for Mac. Outlook Contact List contains data in a format that can be read by Word. See Use Outlook contacts as a data source for a mail merge. Word data file is a data source you can create on the fly, within Word. For more info, see Set up a mail merge list with Word. Also, when I am in Word or Excel, and go to File 'Share', the options to email are once again greyed out. Dec 28, 2014 Go to Tools – Mail Merge Manager; The Mail Merge Manager will then open. Select “Create New” and choose “Form Letters” if you want to send an email. In the main Word document write out your email.

First, some basic principles on mail merge emails for those who aren’t familiar. Mail merge emails are written and managed from Word, not from Outlook. All data that will be “merged” into the email is taken from an excel file. This file should be set up with headings in each column with the first column being email. So you might have columns that read Email, First Name, Surname etc. Whatever fields you have in this file are the fields you will be able to merge into your document. It is very important that you have this set up correctly with email in the FIRST column.

I just tried it and it worked. I'm used to the MS Word order of doing this. It seems a bit weird and backward to put the fields in before telling the file that it is going to use mail merge. Koenig's answer, The problem was not i the operating system, but in the sequence. I just tried it and it worked. I'm used to the MS Word order of doing this. It seems a bit weird and backward to put the fields in before telling the file that it is going to use mail merge. Koenig's answer, The problem was not i the operating system, but in the sequence. Jun 02, 2019 This grayed out options will be enabled when you use the Mail Merge feature in Word. For example, to start the Mail Merge with an Excel file, please follow: 1. In Word, choose File New Blank document. On the Mailings tab, in the Start Mail merge group, choose Start Mail Merge, and then choose the kind of merge you want to run.

Let’s get started…

Make sure your default mail setting is “Outlook”. You can co this by going to “Mail” (the Apple mailbox with the eagle on it) and selecting Preferences – General –Default Email Reader – Outlook. This is essential. It will not work if you don’t do this!
Restart your computer (for some reason I needed to restart before it seemed to remember my preferences).
Make sure your Excel document is set up correctly. Email should be in the first column and each other column with information will need a relevant heading. New recipients then go in each row.
Close your Excel document.
Open word, choose a new blank document.
Go to Tools – Mail Merge Manager
The Mail Merge Manager will then open. Select “Create New” and choose “Form Letters” if you want to send an email.
In the main Word document write out your email. You can merge fields into your document here to personalise it. For example, you may want to write Dear “clients name”. You would do this by dragging the relevant placeholder into the document. It will show up as <<Column Heading>> rather than the actual contents of the column but will merge together before sending and you can preview it in a later step.
Filter recipients using the options button. You might choose to email only certain people in your Excel document. I personally don’t use this and tend to modify my Excel file rather than filter here.
Preview your email by clicking on the <<ABC>> button under “Preview Results”. Here you can flick through each email with the arrows and it will show you how the email will display. Keep in mind that your signature will be added by Outlook. See below for more hints on this.
Click “Generate email messages” and Outlook will open and send your emails.

Hints & Trouble Shooting:

Make sure the account you want to send from is your default account in Outlook.
Outlook will automatically add your signature in but if you use a signature with an image, you may need to remove the image or set it so that it doesn’t use a signature for that account and then include your signature in the word document. I found it didn’t handle my logo well when I let Outlook insert my signature.
If you find that the generate email messages is grayed out this is probably because you failed to restart your computer after changing your default mail reader to outlook (or you skipped this step altogether!)
If you get an error saying “Word was unable to mail your document. Please make sure your mail program is configured correctly and that you can send mail with it” then shut down your computer and start in safe mode by holding the shift key while the computer starts. For some reason this seems to clear the caches or something and fixes the issue.

Hi, This grayed out options will be enabled when you use the Mail Merge feature in Word. For example, to start the Mail Merge with an Excel file, please follow: 1. In Word, choose File > New > Blank document.

This grayed out options will be enabled when you use the Mail Merge feature in Word. For example, to start the Mail Merge with an Excel file, please follow: 1. In Word, choose File > New > Blank document. On the Mailings tab, in the Start Mail merge group, choose Start Mail Merge, and then choose the kind of merge you want to run. To execute Mail Merge, simply select Start Mail Merge from the Start Mail Merge under the Mailings tab. Choose the appropriate selection (letters, emails, etc.) from the dropdown menu, and left click your mouse. Microsoft Word will merge your lists with your documents. You can also select Step by Step Mail Merge Wizard.

Open the mail merge document and choose Yes when Word prompts you to keep the connection. To change addresses in mail merge document Open the mail merge document and choose Edit Recipient List to sort, filter, and choose specific addresses. By Faithe Wempen. After all the codes are inserted in the main document, it’s time to perform the merge. Secure email service for small business. There are three ways to go about this in Word 2016: you can merge to a new document, and then print that document as a separate step after examining the merge results, you can merge directly to your printer, or you can send email messages. Please bring Mail merge wizard back in Word 2016 Anonymous commented September 20, 2018 9:19 PM Flag as inappropriate Flag as inappropriate Delete Mail Merge Wizard is one of the hundreds of things I need to improve Word for Mac.

On the Mailings tab, in the Start Mail merge group, choose Start Mail Merge, and then choose the kind of merge you want to run. Choose Select Recipients > Use an Existing List. Browse to your Excel spreadsheet, and then choose Open.

If Word prompts you, choose Sheet1$ > OK. Then the grayed out would be visible for mail merging for you. For more information about Mail merge in Word, please refer to: Regards, Winnie Liang Please remember to mark the replies as an answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact. Hi, This grayed out options will be enabled when you use the Mail Merge feature in Word. For example, to start the Mail Merge with an Excel file, please follow: 1. In Word, choose File > New > Blank document.

On the Mailings tab, in the Start Mail merge group, choose Start Mail Merge, and then choose the kind of merge you want to run. Choose Select Recipients > Use an Existing List.

Word For Mac Mail Merge Mail Grayed Out Windows 10

Browse to your Excel spreadsheet, and then choose Open. If Word prompts you, choose Sheet1$ > OK.

Office 365

Then the grayed out would be visible for mail mer

Word For Mac Mailmerge Mail Grayed Out