How do I Access Excel as data for mail merge?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm going crazy! I am attempting to use an Excel spreadsheet as the data
source for a mail merge document. When I attempt to access the spreadsheet,
I can view it by using the icon in the mail merge toolbar, but the "edit "
button is grayed out - I cannot edit the data source unless I close Word.
This is VERY inconvenient. The interesting thing is that I have other MM
documents using the same technique, and opening the Word document
automatically opens the data source in Excel and I can readily/easily switch
between the two for editing. What am I doing wrong, please?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge from Access to Word - Loses Data Source 2
Mail Merge using ACCESS 3
Opening mail merge document from access 1
Can Access act as a 'multiple data source' for mail merge to Word? 3
Should I switch from Excel to Access as the data source 4
Mail Merge doesn't update 1
Trouble with some mail merges between MS Access & Word 2
Mail Merge into Microsoft Word using Microsoft Access as data sour 3

Back
Top