Change Macro so it does not refer to "Active Document"

trent.bourne · #1 10-29-2016, 02:44 AM

Hey Guys,

I need help changing this macro so that it runs in the background and does not chuck out an error as the document opens in the background.

I would prefer if I could add some code to bring the document to the front.

The code is

PHP Code:


			
Private Sub Document_Open()



'   Show mail merged folders.. not as <<id>>

    ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False





' Save the file as an PDF File



    ActiveDocument.Save

    ActiveDocument.ExportAsFixedFormat OutputFileName:= _

        "D:\Users\tmb842\Documents\VMPD\Compleated Documents (Mail Merge Finals)\VMPD - Practice First Contact - GP  Dentists.pdf" _

        , ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _

        wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _

        Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _

        CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _

        BitmapMissingFonts:=True, UseISO19005_1:=False

        

    ActiveDocument.Close

    

 

End Sub

macropod · #2 10-29-2016, 03:24 AM

A Document_Open macro runs when you open a document. By definition, that document is both the active document and takes the foreground. When a macro executes a mailmerge, the output document becomes the active document. To see how you might go about implementing a mailmerge via a macro, see Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks 'Sticky' thread at: https://www.msofficeforums.com/mail-...ps-tricks.html

gmayor · #3 10-30-2016, 01:49 AM

If you assign variable names to the documents as you open them (in the same Word instance) and subsequently refer to the documents by those variable names, it will not matter whether they are in the foreground or background, visible or invisible.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
Change "File As" and "Display As" format	davesp	Outlook	0	10-14-2014 12:10 PM
How to Turn Off Message "Search from the beginning of a document" in a Macro	sleake	Word	10	10-15-2013 03:43 PM
How to add a "note" which is "active" when doing a powerpoint show	Anders	PowerPoint	0	01-22-2011 08:47 AM
How do I change the "and" to "or" with multiple Rules (and Alerts)?	bschimmel	Outlook	0	11-16-2009 05:26 AM