Word connectivity (continued)

  • Thread starter Nick 'The Database Guy'
  • Start date
N

Nick 'The Database Guy'

On further research I have found that the code falls over on this
line:

ActiveDocument.MailMerge.OpenDataSource Name:=CurrentDb.Name,
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True,
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="",
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False,
Format:=wdOpenFormatAuto, Connection:= "Provider=Microsoft.Jet.OLEDB.
4.0;Password="""";User ID=Admin;Data Source=currentdb.name;Mode=
Read;Extended Properties=""""; Jet OLEDB:System database="""";Jet
OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet
OLEDB:Engine", SQLStatement:="SELECT * FROM `qrySource`",
SQLStatement1:="", SubType:=wdMergeSubTypeAccess

It works the first time but the second time I run this procedure I get
the error:

Error number : 462

Error description: The remote server machine does not exist or is
unavaiable.

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mailmerge recorded macro 0
Word Table saved as ActiveX in Access, how to display in Word 0
Macro doesn't work any more 0
VBA Word: Mail merge labels printing 0
Mail Merge Programming problem 1
Mailmerge FindEntry problem 0
Word connectivity 0
Mail Merge from Access with datasource being a password protected 2

Top