mailmerge from access database using DDE connection?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 11 Jan 2006 15:33 GMT

Is there a way to tell Word to use an old-style DDE connection instead of the
OBDC connection. my particular problem involved the use of coding that I
wrote in a macro to compile a summary of items from different records. It
seems that mailmerge doesnt like my query which contains user-defined
functions. Prior to upgrading word the mailmerge worked without a flaw.
thanks for the help in advance. ~Mike

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2006 18:46 GMT

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is there a way to tell Word to use an old-style DDE connection instead of
> the
[quoted text clipped - 3 lines]
> functions. Prior to upgrading word the mailmerge worked without a flaw.
> thanks for the help in advance. ~Mike

Reply to this Message

Mike - 11 Jan 2006 19:27 GMT

doug, thanks for the quick reply. I have done this and still am running into
problems. it seems like the user defined code that i wrote in visual basics
is the cause of my problems. upon switching to another record in mailmerge
the letter freezes up and takes a long time to switch. any suggestions?

> From the Tools menu in Word, select Options and then go to the General tab
> and check the box against the "Confirm conversions at open" item. Then when
[quoted text clipped - 8 lines]
> > functions. Prior to upgrading word the mailmerge worked without a flaw.
> > thanks for the help in advance. ~Mike

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2006 21:00 GMT

Maybe you need to change what you are doing in Access so that it creates a
new table which you can use as the datasource.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> doug, thanks for the quick reply. I have done this and still am running
> into
[quoted text clipped - 22 lines]
>> > flaw.
>> > thanks for the help in advance. ~Mike

Reply to this Message