Mail Merge data source error - can anyone help?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

intruder1@gmail.com - 21 Aug 2006 09:59 GMT

Hi everyone,

I hope you can help. I have an Access MDB and I'd like to extract the
records for mail merging directly from within Access.I've set up the
macro which calls up Word from within Access with the appropriate data
on two of my machines and it works perfectly, but on two others I get
the following error message.

" The method or property is not available because the current mail
merge main document needs a data source".

I have no idea what could be causing this or what I need to do to
resolve it, moreso as two machines run perfectly well with, I believe,
all 4 having the same settings!

Any help would be really appreciated, thanks!

Reply to this Message

Cindy M. - 21 Aug 2006 11:35 GMT

> I hope you can help. I have an Access MDB and I'd like to extract the
> records for mail merging directly from within Access.I've set up the
[quoted text clipped - 4 lines]
> " The method or property is not available because the current mail
> merge main document needs a data source".

Unfortunately, you haven't specified which version of Word you're
working with, so we can only guess that...

What you're seeing is a result of what's discussed in this article

"Opening This Will Run the Following SQL Command" Message When You Open
a Word Document - 825765
http://support.microsoft.com?kbid=825765

When this security option is active, and a mail merge document is opened
using code, the data source is automatically removed from the document.
In this case you have two choices:
1. Set the Registry key mentioned in the article to suppress the
security measure

2. Link back up to the data source after opening the document
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

Reply to this Message

Dave Jennings - 21 Aug 2006 12:06 GMT

> Unfortunately, you haven't specified which version of Word you're
> working with, so we can only guess that...
>
> What you're seeing is a result of what's discussed in this article

Cindy,

Many thanks for this, I really appreciate that. Sorry for omitting my
Word version, what a basic error! It's 2003, for the record.

Again, many thanks.

Best regards,

Dave.

Signature

Dave Jennings

Reply to this Message

Rate this thread: