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?
 
Hi Randy,

You'll have better luck answering an Excel question in an Excel newsgroup.
This one is for Access database users. We could answer your question if it
were for a mail merge with an Access database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

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
Can Access act as a 'multiple data source' for mail merge to Word? 3
Opening mail merge document from access 1
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