SAVING AUTOMERGED DOCUMENT ACCESS
SUB :: I NEED TO SAVE THE AUTOMERGED DOCUMENT ACCESS
I HAVE AUTOMATED THE ACCESS TO MERGE THE MAIN DOCUMENT INTO THE NEW DOCUMENT
THE CODE IS AS FOLLOWS
PATH ="C:\LOANS\MAIN.DOC"
Set objWord = GetObject(PATH, "Word.Document")
objWord.Application.Visible = True
objWord.MailMerge.OpenDataSource _
Name:=CurrentDb.Name, _
LinkToSource:=True, _
Connection:="TABLE Applicant-Loan Information", _
SQLStatement:=stmt
' Execute the mail merge.
objWord.MailMerge.Execute
I AM NOT ABLE FIGURE OUT A WAY TO SAVE THE NEW MERGED DOCUMENT
IF I TRY TO SAVE WITH THE CODE AS UNDER
objWord.SAVEAS "C:\NEWDOC.DOC"
THE STATEMENT SAVES THE MAIN DOCUMENT
NEED HELP
THANKS IN ADVANCE
REGARDS
|