Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 27th, 2003, 11:13 PM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
 
Old June 28th, 2003, 04:45 AM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default



GOT THE CODE BASICS

PLEASE CHECK THIS SITE

http://www.tek-tips.com/gfaqs.cfm/pid/705/fid/3237







Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to Word not saving BeckyMack Access 0 April 9th, 2008 07:16 AM
Problem saving a word document using DSOFramer Act Chirantan Pro VB.NET 2002/2003 0 August 28th, 2007 08:02 AM
Saving a document on local computer h2c357 Javascript 0 May 3rd, 2007 09:14 AM
Regarding saving the document Hari_Word Excel VBA 1 October 29th, 2004 10:49 AM
saving word document in server asp sdeep_us Classic ASP Basics 1 August 7th, 2004 10:30 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.