473,480 Members | 1,814 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

access switchboard launching mail merge broken

I am trying to have a button that launches a word mail merge document
thats already linked to my database. when i hit the button, word opens
with the file, but all the mail merge features are greyed out.

what am i doing wrong?
i am using office xp, and here is my code:
Public Function LaunchMerge()
On Error GoTo Err_LaunchMerge

Set mobjWordApp = CreateObject("Word.Application")
With mobjWordApp
.Visible = True
.WindowState = wdWindowStateMaximize
.Documents.Open ("T:\ALL VET UNIT INFOMATION\All TAP
Infomation\Tap Employers Database\tap.doc")

End With

Exit_LaunchMerge:
Exit Function

Err_LaunchMerge:
MsgBox Err.Description
Resume Exit_LaunchMerge
End Function

Nov 9 '06 #1
2 1740
Also, when i open tap.doc through explorer, it does work fine, but
sometimes it complains that the database is locked. is there any way to
stop access from locking it? i have default open mode set to shared and
default record locking set to no locks.

Deus402 wrote:
I am trying to have a button that launches a word mail merge document
thats already linked to my database. when i hit the button, word opens
with the file, but all the mail merge features are greyed out.

what am i doing wrong?
i am using office xp, and here is my code:
Public Function LaunchMerge()
On Error GoTo Err_LaunchMerge

Set mobjWordApp = CreateObject("Word.Application")
With mobjWordApp
.Visible = True
.WindowState = wdWindowStateMaximize
.Documents.Open ("T:\ALL VET UNIT INFOMATION\All TAP
Infomation\Tap Employers Database\tap.doc")

End With

Exit_LaunchMerge:
Exit Function

Err_LaunchMerge:
MsgBox Err.Description
Resume Exit_LaunchMerge
End Function
Nov 9 '06 #2
Also, when i open tap.doc through explorer, it does work fine, but
sometimes it complains that the database is locked. is there any way to
stop access from locking it? i have default open mode set to shared and
default record locking set to no locks.

Deus402 wrote:
I am trying to have a button that launches a word mail merge document
thats already linked to my database. when i hit the button, word opens
with the file, but all the mail merge features are greyed out.

what am i doing wrong?
i am using office xp, and here is my code:
Public Function LaunchMerge()
On Error GoTo Err_LaunchMerge

Set mobjWordApp = CreateObject("Word.Application")
With mobjWordApp
.Visible = True
.WindowState = wdWindowStateMaximize
.Documents.Open ("T:\ALL VET UNIT INFOMATION\All TAP
Infomation\Tap Employers Database\tap.doc")

End With

Exit_LaunchMerge:
Exit Function

Err_LaunchMerge:
MsgBox Err.Description
Resume Exit_LaunchMerge
End Function
Nov 9 '06 #3

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

Similar topics

6
3690
by: Ecohouse | last post by:
I have a computer with XP on it. I loaded Office 97 first because I needed Access 97 for some work. I then loaded Office 2000. Everything seemed to be running fine. But I have come across a few...
9
4307
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...
3
2339
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...
3
5565
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...
4
7461
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...
0
1637
by: Sheila | last post by:
I have set up a Word mail merge document of the type Directory which allows me to display all of the records on a single page rather than putting each record on a separate page. It uses a...
8
13321
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...
0
271
by: Deus402 | last post by:
I am trying to have a button that launches a word mail merge document thats already linked to my database. when i hit the button, word opens with the file, but all the mail merge features are...
1
6525
by: Esther Lane | last post by:
Hello! First off, many many thanks to Albert who wrote the Mail Merge code for MS Access I am using. It has been working beautifully for a few years. However, my client just (without notice!)...
0
7037
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,...
1
6732
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5324
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,...
1
4768
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...
0
4472
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...
0
2990
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...
0
1294
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
558
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
174
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.