Mail Merge Drive Me Crazy

[dan.cawthorne]

Hi all,

Ive recently upgraded me access from 2k3 to 2k7 every thing seems to
be running fine about from my mail merges to word 2007,

I've tried all the connection types and the new inbuilt mail merge
options and all are failing.

I have a query that has fields from 2 Tables. which has the
information i want to print - use to work in Access 2003.

on 90% of the connection types to the mailmerge im only ever shown
tables or querys bases on 1 table. anything else it doesnt like.

So from word ive clicked on the following Mailings > Select
Reciptients > Select Existing List > Other/Advanced > Microsoft Jet
4.0 OLE Provider > Then i select my front end database where query is
located - Then a List of Querys Based on one table and Tables are
listed. and if i select a table or query. the mail merge connection
works.

But thas not what i want.

I've tried Right Clicking on my query which is based on two tables and
doing the export via mail merge so i follow the steps.

and i select create new word document. Word Opens. asking me to select
my table/query i select the Query and then access flashes orange and
then i open access and Im Promted with a Message "Word Was Unable to
open the data source"

as any one got any ideas?

Please help?

regards

Dan

 

[Maurice]

Hi Dan,

Had some issues with that one myself. Check this link to see the explanation:

http://support.microsoft.com/kb/888697/en-us

hth

 

[Dan]

Hi Dan,

Had some issues with that one myself. Check this link to see the explanation:

http://support.microsoft.com/kb/888697/en-us

hth
--
Maurice Ausum















- Show quoted text -

Thank you Maurice,

So the answer is that i need to make an DDE connection to the Query
and everything works? first issue sorted.

so has any one got any ideas why when doing this, it opens another
instance of the database. surely it should find the information via
the database already open.

Regards

Dan

 

[Maurice]

basically it's a bug but described as a workaround because DDE is old
technology.

 

[Dan]

basically it's a bug but described as a workaround because DDE is old
technology.
--
Maurice Ausum








- Show quoted text -

DDE old technology, we seems to work great for me with multiply table
querys. using the DDE replacement technology does seem to like these
sort of querys.