![]() |
#1
|
|||
|
|||
![]()
I recorded a Word doc macro to update a Mail Merge based on an excel sheet array and then save as a PDF. It works almost exactly how I want, but I'm trying to customize the saved file's name. I know it's somewhere in the bold line below (with my attempt at it), can anyone tell me what I'm doing wrong?
ActiveDocument.ExportAsFixedFormat OutputFileName:= _ "C:\Users\j***\Desktop\" & Range("City") & ", " & Range("State") & " - GC Bid Instructions.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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
gogreen | OneNote | 1 | 07-27-2016 09:38 AM |
![]() |
xdhbsh | Mail Merge | 3 | 12-24-2015 12:23 AM |
![]() |
ottman88 | Mail Merge | 4 | 06-05-2015 03:16 AM |
converting a word document to a data file for mail merge | drsuis | Mail Merge | 4 | 02-21-2013 03:34 PM |
Trying to merge label data from file | ClayShannon | Mail Merge | 0 | 09-16-2009 10:08 PM |