I'm sure this has been ansered before and I do appolgize in advance.
Here is my situation, I have a secured MDB file FE which creates a
temp table to use as a merge document. I have created a Merge
document with the proper fields. Using Q209976 article as a guide I
created a module called Mergeit with the following code:
Dim objWord As Word.Document
Set objWord = GetObject
("K:\predator\templates\example.doc", "Word.Document")
objWord.Application.Visible = True
objWord.MailMerge.OpenDataSource _
Name:="K:\predator\predator.mdb", _
LinkToSource:=True, _
Connection:="TABLE AtblContactInformation", _
SQLStatement:="SELECT * FROM [Atblcontactinformation]", _
OpenExclusive:=True
objWord.MailMerge.Execute
Here are my issues:
1. it asks the user if they want to add the SQL statement to the
document.
2. It brings up the Data Link Properties Window with the full path
of the database and the User: Admin and Passwords are blank. If I
click ok i get "You don't have permissions to use the mdb....", If
I cancel then it opens a new merge document along with the orignal
word document.
Sorry for such a long post, but I'm not that familure with
MergeAutomation as much as using the bookmark method.
Any help would greatly be appreciated.
Eieen
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
