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

You can't just use Range("City") or Range("State") - you need to say where they come from; otherwise the code will assume they are Word ranges. Furthermore, unless each 'excel sheet array' spans only a single cell, neither Range("City") nor Range("State") would output anything.

To see how to get the relevant field values (and save the output), have a look at Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks 'Sticky' thread at the top of the Mailmerge forum: https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you, that link solved it!

Would there be a reason then that it doesn't work running a macro in Excel? I have the excel vba as shown below, it will open the source document, but won't run the word macro. But if I run said macro directly through word it does fine. I tried finding a solution, but from what I can tell it should work?

Sub Create_Mailmerge_PDF()
Set appWd = CreateObject("Word.Application")
appWd.Visible = True
appWd.Documents.Open Filename:="C:\Users\j***\Source Doc.docx"
appWd.Run "Mailmerge_PDF"
End Sub

For starters, if the Word document you're trying to open is a mailmerge main document, the whole process will stall as soon as the document opens, because Word will be waiting for you to respond to the SQL prompt that you get when opening such a document.

There are ways around that, but the coding becomes a whole lot more complex. See, for example: https://www.msofficeforums.com/mail-...html#post61768. Even that code doesn't generate the individual Word documents - you'd need to integrate the two approaches.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you again very much!