Word: Reattach Excel mail merge data source
On the View menu, and then click Mail Merge to display the Mail Merge toolbar. In Word 2007 or Word 2010, the mail merge toolbar is in the Mailings tab, and includes the Start Mail Merge group, the Write and Insert Fields group, the Preview Results group and the Finish group. Note The options on the Mail Merge toolbar offer similar functions as.
- If you have difficulties in completing a Merge to eMail using MS-Word from a MS-Excel Spreadsheet as Data Source - hopefully this video will be of assistance.
- If Merge to E-Mail is grayed out, it means Word doesn't think that Outlook is the default email client. I've seen two situations for this—one is addressed with that command in case Mail stubbornly keeps itself as the default email client, and the other is the corresponding Outlook version not being installed.
A 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’!)
Email Merge Is Greyed Out In Word Form
That’s it. All the Mailings tab options are now available to you.
Merge To Email Greyed Out In Word Mac
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.