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

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