No queries option using Access DB as Word MailMerge datasource

[Guest]

Hi,

I'm using Office 2003 (SP2) and Windows XP. Another user on the same server
is using Office 2003 with Windows 2000 (?).

My problem is that when mail merging to Word queries don't appear as an
option but they do on the other users machine.

I've spoken to our tech dept who say that this is just something that
happens and that I could export query to Excel.

Strangely enough I just want to click and go (thought that was the point)

Could anyone out there tell me what the difference is in the set up and do I
just have to resign myself to not being able to mail merge from all our
carefully set up Queries. Or is there a doable solution.

TIA

 

[Albert D. Kallal]

the problem is perhaps that some different version of a odbc driver, or even
multiple versions of ms-access are installed on that target machine.

the best solution is to simply NOT let word connect to ms-access, and your
problem is solved.

I have a solution that been running for 7+ years with MANY clients, and
every conceiving mix of DIFFENT version OF access, excel, and word have
NEVER failed for me.

In other words, many problems occur, and you example is just one of many...

So:

Two suggestions:

1 Always use late binding for your word automaton code via ms-access
(that means NO word references)

2 Don't let word attached to the mdb file, since there is could
security on the mdb file, there could be two versions of ms-access, and word
gets confused, and further, as in your case, it could one of 10,000
different .dll versions, or drivers installed. These are HUGE applications
with millions of files an dependants....

You can find a copy of the reliable solution that works here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Grab the super easy word merge. There is a sample form that lets you select
a query, and send it to word.

What the above sample simply does is export the query data to a text (csv)
file, and the attaches the word merge to that text file.....

 

[Guest]

Many thanks for quick response. Will try and let you know tomorrow