i would like to run through my database and
merge in a word 2007 document (several page .docx)
save that word document as pdf
(do that for several word documents)
zip all pdfs
email
i have the code for the loop and the merge and email. works well. I am stuck on the save as pdf and zip all pdfs.
i tried
objWord.ActiveDocument.ExportAsFixedFormat OutputFileName:= _
strFileName, ExportFormat:=wdExportFormatPDF, _
OpenAfterExport:=False, OptimizeFor:=wdExportOptimizeForPrint, Range:= _
wdExportAllDocument, From:=1, To:=1, Item:=wdExportDocumentWithMarkup, _
IncludeDocProps:=True, KeepIRM:=True, CreateBookmarks:= _
wdExportCreateNoBookmarks, DocStructureTags:=True, BitmapMissingFonts:= _
True, UseISO19005_1:=True
I get an error. I can save as PDF from within Word. I did download the addin.
and i can't even think of what to do about zipping the files
thanks
merge in a word 2007 document (several page .docx)
save that word document as pdf
(do that for several word documents)
zip all pdfs
i have the code for the loop and the merge and email. works well. I am stuck on the save as pdf and zip all pdfs.
i tried
objWord.ActiveDocument.ExportAsFixedFormat OutputFileName:= _
strFileName, ExportFormat:=wdExportFormatPDF, _
OpenAfterExport:=False, OptimizeFor:=wdExportOptimizeForPrint, Range:= _
wdExportAllDocument, From:=1, To:=1, Item:=wdExportDocumentWithMarkup, _
IncludeDocProps:=True, KeepIRM:=True, CreateBookmarks:= _
wdExportCreateNoBookmarks, DocStructureTags:=True, BitmapMissingFonts:= _
True, UseISO19005_1:=True
I get an error. I can save as PDF from within Word. I did download the addin.
and i can't even think of what to do about zipping the files
thanks