473,395 Members | 1,343 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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 1737
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
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
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
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
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
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
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
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
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
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
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.