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 / January 2008

Tip: Looking for answers? Try searching our database.

MailMerge cannot merge on some user

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary Lam - 11 Jan 2008 02:12 GMT
There are some user accounts in my company they cannot use the mailmerge
function that provided by our .Net application anymore.

The system use to be working fine. After we upgraded to Word 2003 from 2000.
The problem start happening.

It shouldn't be a coding problem. As we never change the code. The only
change is the Office upgrade.

In OFfice 2003, I notice that there are a security issue in connecting a
data source with a  template and create a new file.

However, I look in the internet, most of the post is just telling me to by
pass SQL Security Check

http://support.microsoft.com?kbid=825765

I applied the fix to the server. However, it still doesn't work. Note: My
data file is a word document, rather than a SQL connection.

Here is my error message:

System.Runtime.InteropServices.COMException (0x800A11FD): This method or
property is not available because the current mail merge main document needs
a data source.
  at Word.MailMerge.Execute(Object& Pause)

Thanks for your help,
Peter Jamieson - 11 Jan 2008 08:54 GMT
You have to apply the fix to the computer where the merge is being
performed. That is probably on the user workstations in this case.

> I applied the fix to the server. However, it still doesn't work. Note: My
> data file is a word document, rather than a SQL connection.

Word uses a dialect of SQL even when it connects to data sources that it
reads using its "internal converters."

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> There are some user accounts in my company they cannot use the mailmerge
> function that provided by our .Net application anymore.
[quoted text clipped - 26 lines]
>
> Thanks for your help,
Martin Reyerink - 12 Jan 2008 08:11 GMT
I had a similar problem when our SQL Server had a critical update installed
which affected MDAC. The problem was fixed by renaming / delting user
profile's which had this problem. The problem is caused by a corrupted MDAC
config for users office profile. We tried everything else (MDAC service pack,
Office service pack, Office Repair) before this method worked.

When deleing user profiles all there customised setting will be deleted..
 
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.