X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Mail Merge, Any Version    
post Feb 18 2020, 02:39 PM

Posts: 1,172
Joined: 19-February 08

I use Excel or Access with word for mail merge
Is there any way or macro to save individual page as pdf in a folder on a drive
with a name of inserted mail field

Thank you so much

I would like to Thank you for your help
Go to the top of the page
post Feb 19 2020, 12:46 AM

Posts: 3,550
Joined: 27-February 09

Maybe a combination of Albert Kallal's "Super Easy Word Merge" and then you force Word to save as PDF instead of a normal Word file.

Sub SaveAsPDF()
' SaveAsPDF Macro
    ActiveDocument.ExportAsFixedFormat OutputFileName:= _
        "C:\Users\ME\OneDrive\Documents\MyPDFFile.pdf" _
        , ExportFormat:=wdExportFormatPDF, OpenAfterExport:=True, OptimizeFor:= _
        wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _
        Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _
        CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _
        BitmapMissingFonts:=True, UseISO19005_1:=False
    ChangeFileOpenDirectory "C:\Users\Pieter\OneDrive\Documents\"
End Sub

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    31st March 2020 - 09:15 AM