473,851 Members | 2,037 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003 mail merge using DDE

Okay I know this is probably not the best way to be doing things but I
have an ancient application that was working fine until a end user got
a new machine. The Access database is performing a mail merge. The
Word Document is linked to a temp table in the Access database. It
used to work fine in the past with DDE. Yes it opens another copy of
the database but it doesn't really matter and it worked.

So now with Access 2003 and Word 2003 it tells me that it can initiate
the DDE link. Works fine on my computer with Access 2003/Word 2003. I
installed service pack 2 and still the same problem. I didn't do the
office installing and am wondering if DDE is something that needs to be
installed?

Feb 6 '06 #1
4 3907
"Access" <al*********@gm ail.com> wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com:
So now with Access 2003 and Word 2003 it tells me that it can
initiate the DDE link. Works fine on my computer with Access
2003/Word 2003. I installed service pack 2 and still the same
problem. I didn't do the office installing and am wondering if
DDE is something that needs to be installed?


Why not just change the merge document to use ODBC and stop worrying
about troubleshooting a technology (DDE) that's been out of date for
at least 10 years?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Feb 6 '06 #2
You can't answer someone who is making a question on a technology, to
switch to another, just because you are not able to help. He may have
good reasons to do so. That's very rude.

-Pam

Feb 7 '06 #3
The one that works on your computer is not by chance an mdb file and the one
on your client's new machine, an mde compiled version is it? I have had a
similar problem where the merge worked fine for me and not for the client,
then I discovered that it only works on an mdb and not an mde.

dixie

"Access" <al*********@gm ail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
Okay I know this is probably not the best way to be doing things but I
have an ancient application that was working fine until a end user got
a new machine. The Access database is performing a mail merge. The
Word Document is linked to a temp table in the Access database. It
used to work fine in the past with DDE. Yes it opens another copy of
the database but it doesn't really matter and it worked.

So now with Access 2003 and Word 2003 it tells me that it can initiate
the DDE link. Works fine on my computer with Access 2003/Word 2003. I
installed service pack 2 and still the same problem. I didn't do the
office installing and am wondering if DDE is something that needs to be
installed?

Feb 7 '06 #4
I would guess macro security: do you still have the
problem if macro security is set to Low?
DDE is not something that needs to be installed.

It is still used by Windows Explorer for starting
and running some things.

DDE link failures were one of the reasons MS moved
to OLE automation. It has always been difficult to
debug.

I don't have any useful suggestions about debugging
DDE: ODBC works well, can you modify the app to use
ODBC mailmerge?

(david)
"Access" <al*********@gm ail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .
Okay I know this is probably not the best way to be doing things but I
have an ancient application that was working fine until a end user got
a new machine. The Access database is performing a mail merge. The
Word Document is linked to a temp table in the Access database. It
used to work fine in the past with DDE. Yes it opens another copy of
the database but it doesn't really matter and it worked.

So now with Access 2003 and Word 2003 it tells me that it can initiate
the DDE link. Works fine on my computer with Access 2003/Word 2003. I
installed service pack 2 and still the same problem. I didn't do the
office installing and am wondering if DDE is something that needs to be
installed?

Feb 8 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3871
by: bmoos1 | last post by:
I have MS Office 2000 and upgraded Access Only to 2003. The problem is I want to use my Access queries for a mail/merge, but I get the error message: "Word could not re-establish DDE connection to Microsoft Access to complete the current task" I can do mail/merge from Excel with no problems. I can use ODBC to
9
4332
by: Neil Ginsberg | last post by:
I have a strange situation using Access to automate a Word mail merge. Using Access 2000 and Word 2000, the code opens Word, opens the document in Word, sets a table in the calling Access application as the data source, and then performs a merge. Everything works fine. However, when a user uses it in Access 2002 and Word 2002, an extra instance of the Access application is opened and remains open at the end. Sometimes it remains open
3
1539
by: arthur-e | last post by:
My access 97 database worked great until our I.S. upgraded to Win2000/Office 2000 in order to install a printer (Novell is running too) and the machine was NT - and a USB port was needed. After I found out that Office 2000 Pro was installed (YIKES - no Access 97) we took off Access 2000 and re installed Access 97. BUT Mail Merge (Word 2000) is flakey. A button on an access form opens a word document with info from the
3
2372
by: Strasser | last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!). Doesn't work when using XP version of both Access and Outlook, even though I checked the box to ensure that I was sending the email. Any ideas? Thanks in advance.
3
5593
by: Andy Davis | last post by:
I have set up a mail merge document in Word 2003 which gets its data from my Access 2000 database. I want to set up a button on a form that: 1. runs the query to provide the dat for the merge document in Word; 2. opens the document and runs the merge process for the new data. I have managed to write the code to perform step 1 ok, but I'm having trouble with step 2. It opens the word document fine but does not perform the mail merge of...
4
7477
by: pmhaupt2 | last post by:
I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and associated it with a specific query in my Access database. My problem is that when I run my "create letters" button from an Access form, the program opens up Word correctly with the proper letter. However, the MailMerge toolbar in Word appears...
0
1550
by: pnr | last post by:
I transferred my database to a new computer. I can open it in 2003 Access, but am keeping it in the 2000 version until I get it working correctly. I have dozens of Word documents where I use various Access queries as my datasource. Now when I try to mail merge in Word (for some, not all, of my documents.) Word mail merge message may say it can't find the data source. So it gives me a data selection box and I choose my transferred...
0
1810
by: Darragh | last post by:
I'm encountering some serious problems trying to set Access 2000 querys (parameters and views) as data sources for my mail merge documents (Word 2003). After spending hours scouring the web for some existing help and coming up with nothing, its time to admit defeat and ask here ! Trying to set the data source to a preexisting query via DDE results in an 'Unable to establish DDE connection' - similar to the error described at...
8
13343
by: Ron B | last post by:
Help!!! What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table. I want to make the mail merge seamless to the user so all they have to do is click on the command button and the letters are generated. For the button I created an event procedure with the following code: Private Sub RunLetters_Click()
0
9897
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9747
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11019
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9506
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7906
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7073
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5736
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5933
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4143
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.