I have done word automation before using bookmarks but now I need to make one
of the forms a mail merge instead. My database both (FE) and (BE) are running
under a secured MDW file. In googling a example I found this: But it is
returning an error
My Code is:
Function TestUADMerge()
Dim objWord As Word.Document
Set objWord = GetObject("K:\predator\templates\CA99107g.doc", "Word.Document")
objWord.Application.Visible = True
objWord.MailMerge.OpenDataSource _
Name:="C:\program files\predator\predator.mdb", _
LinkToSource:=True, _
Connection:="TABLE MtblUADPOL2", _
SQLStatement:="SELECT * FROM [MtblUADPol2]"
objWord.MailMerge.Execute
End Function
The highlighted area is where it is stopping.
Any help would be great.
Thanks
Eileen
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
AIDS in India: A "lurking bomb." Click and help stop AIDS now.
http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
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/
