Re: How to stop source prompt in mail merge from access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Are you calling OpenDataSource in your Access code? If not, it would
probably be a good idea to do so, but you will need to remove any existing
connection from the Word mail merge main document because Word will try to
open the existing connection before any OpenDataSource method call can
execute (whether it is in Access or Word). Removing the existing connection
will lose any sort/filter options but all the field codes etc. remain
intact.

If so, you need to use something along the following lines:

Dim sConnaection As String
Dim sName As String
Dim sSQL As String

sName:="the full path name of your Access database"

sConnection="TABLE tablename"
' or
' sConnection = "QUERY queryname"

' If you need to sort or filter the data, use ORDER BY
' and/or WHERE clauses in here
sSQL = "SELECT * FROM [table or query name]"

oWordDocumentObject.OpenDataSource _
Name:=sName, _
Connection::=sConnection, _
SQLStatement:=sSQL, _
Subtype:=wdMergeSubtypeWord2000

NB if you don't add a reference to the Word object library in the Access VBA
editor, you will need to use

Subtype:=8

Peter Jamieson

"mvb" <mvb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:654676F7-1191-48C6-80B1-E1516CEB2873@xxxxxxxxxxxxxxxx
> The mail merge is being called from the Access database via a Visual Basic
> function. The message that comes up is:
> Data Link Properties
> Connection
> Specify the following to connect to Access Data
> 1. Select or enter a database name
> (default to open db)
> 2. Enter information to log onto the database
> User Name: Admin
>
> When Cancel is selected a second page pops up called
> Login
> Data Source MS Access Database
>
> When Cancel is selected the mail merge proceeds using DDE.
>
> Any ideas?
>
>
> "Peter Jamieson" wrote:
>
>> What does the pop-up say?
>>
>> Peter Jamieson
>> "mvb" <mvb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:1FB0C285-774F-4D1F-8396-BA8E942ACFB4@xxxxxxxxxxxxxxxx
>> > No luck with a. I'm afraid. The merge does work when the pop-up asking
>> > for
>> > data source location is cancelled. The link is in DDE and it goes
>> > ahead
>> > ok -
>> > it's just a nuisance having to cancel the pop-up each time the merge
>> > is
>> > run.
>> > What does method b. involve?
>> >
>> > Mvb
>> >
>> > "Peter Jamieson" wrote:
>> >
>> >> If nothing else works, you can try:
>> >> a. changing the method Word uses to connect to Access (check Word
>> >> Tools|Options|General|Confirm conversions at open, and go through the
>> >> connection process again). In Word 2003, the default method is OLEDB,
>> >> but
>> >> you should be able to choose DDE (the old method) or ODBC.
>> >> b. setting up an appropriate .odc or .udl file and opening that
>> >> instead -
>> >> you may need that if your database is secured via workgroup security.
>> >> If
>> >> (a)
>> >> doesn't work and you need to use (b), I'll try to explain more.
>> >>
>> >> Peter Jamieson
>> >> "mvb" <mvb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:7CF7F45C-1C9A-42AB-A7F5-C99472156F59@xxxxxxxxxxxxxxxx
>> >> > When starting a mail merge from access to word 2003, word prompts
>> >> > for
>> >> > location of the data source every time even though the merge has
>> >> > been
>> >> > saved.
>> >> > This behaviour is new with word 2003 and did not occur with word
>> >> > 2000.
>> >> > Microsoft acknowledged the problem and provided an update (885832 &
>> >> > 887979)
>> >> > but this didn't have any effect. Any suggestions???
>> >> > Thanks.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: How to use access query computed fields in Word mailmerge
    ... Once you have gone through the connection process once, ... To make a DDE connection in code from Word 2000/2002 I think you will need ... My access databases have lots of these computed query ... >>> an access database with any data in it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • Re: JDBC Applets - MS Access
    ... > I am working on a Applet at the moment which must be able to access ... > I need to be able to setup a jdbc connection to an Access database. ... JDataConnect also uses a server side JDBC server. ...
    (comp.lang.java.databases)
  • Re: connecting to a database
    ... install at Beta sites, I would like to use an Access Database to store ... I have no idea how to set up a connection. ... connection to an Access Database that they would be willing to post. ... There are no real JDBC driver for MS Access. ...
    (comp.lang.java.programmer)
  • Insert a bitmap image into excel via maccess code
    ... I can update or insert data from an access database into an excel file from ... excell spreadsheet where the bitmap image is stored in a field in a table in ...
    (microsoft.public.access.formscoding)