Create your Excel Spreadsheet. The most important step in the mail merge process is to set. Word 2016 For Mac Merge To Email Greyed Out 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. 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. In the last step the 'generate e-mail messages' option should not be greyed out.
Word: Reattach Excel mail merge data source
September 27, 2011A few times my colleagues and I have experienced the situation where a mail merge template lose its connection to its data source (in my client’s case, an Excel spreadsheet). I suspect it’s because Word is storing the file path to the data source somewhere that we can’t see or find. I’ve been setting up the letter template and the data source on my computer and then emailing the files to my colleagues, who’ve then dropped the files onto a network drive or into a local folder. Sometimes the mail merge works; other times they just get grayed out options on the Mailings tab in Word 2007 (likely the same in Word 2010).
I figured out a quick fix to reattach the data source to a Word 2007 mail merge letter template:
- Mailings tab > Select Recipients > Use Existing List.
- Navigate to and select the Excel spreadsheet (or other data source if you’re not using Excel), then click Open.
- Select the worksheet in the Excel file when asked (in my client’s case, it’s the well-named ‘Sheet 1’!)
That’s it. All the Mailings tab options are now available to you.
Email Merge Is Greyed Out In Word Form
If you know of any way to find out what source a particular mail merge is using, or how to find the stored file path for the data source, I’d appreciate it if you could add that information to the comments below.
Symptoms
In Microsoft Word, when you create a mail merge document and then use the Mail Merge Wizard to insert the address block, the resulting address may not be in the correct format for all of the recipients.
For example, when you address mail to an individual at a corporate address in England, the name of the company should come first and then the name of the individual. In the United States, the name of the individual should come before the name of the company.
When you insert the address block from the Mail Merge Wizard into a mail merge document, the name of the individual always comes first, regardless of how the address is arranged in the address database.
Cause
This issue occurs because the address block in Word has only one format for each language.
Workaround
To work around this issue, insert individual address field names in the order that you want them to appear on an address. To insert individual field names, follow these steps:
Why Is Merge To Email Greyed Out
In Microsoft Office Word 2003 or in Microsoft Word 2002, point to Letters and Mailings on the Tools menu, and then click Mail Merge Wizard.
In Microsoft Office Word 2007, click Start Mail Merge in the Start Mail Merge group on the Mailings tab, and then click
Step by Step Mail Merge Wizard.In the Mail Merge task pane, click Next until you reach step 3 of 6.
Under Use an existing list, click Browse.
In the Select Data Source dialog box, browse to the list that you want, and then click Open.
In the Mail Merge Recipients list, click OK.
Click Next to proceed to step 4 of 6.
Click More items.
In the Insert Merge Field dialog box, click Database Fields.
In the Fields box, click the field name that you want to appear first in the address, and then click Insert.
Click Close, and then place the insertion point where you want the next field name to appear.
Repeat steps 7 through 10 until all the address data fields are placed where you want them.