Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Edit Button in Mail Merge Greyed Out

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kathi Scearce - 17 Aug 2004 20:15 GMT
I'm using Office 2003. When I do a mail merge and open up
my data source, the edit button is greyed out and I can't
edit the database unless I open up my Access file and edit
from there.

Has anyone seen this before? Any suggestions?
Peter Jamieson - 18 Aug 2004 10:04 GMT
I think it is normal in Word 2003 when you are using the default connection
method (OLEDB) unless your data source was created using the facilities in
the Mail Merge Wizard - in that case, the resulting .mdb file has a specific
structure that Word recognises as an "Office Address List" and allows you to
edit. Otherwise, I think your only options are to open the table using the
DDE connection method (in which case Access opens, and you can edit the data
in there, and that's where the Edit button leads you) or the ODBC method (in
which case you have to reply "Yes" when Word asks you if you want to use MS
Query to edit, and you have to have MS Query on your system). To change the
connection method, check Word Tools|Options|General|"Confirm conversions at
open", then re-connect to the data source.

Signature

Peter Jamieson

> I'm using Office 2003. When I do a mail merge and open up
> my data source, the edit button is greyed out and I can't
> edit the database unless I open up my Access file and edit
> from there.
>
> Has anyone seen this before? Any suggestions?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.