Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-25-2018, 02:26 PM
constructionjasont constructionjasont is offline Using Merge Data to Customize a File Name Windows 10 Using Merge Data to Customize a File Name Office 2016
Novice
Using Merge Data to Customize a File Name
 
Join Date: Jun 2017
Posts: 13
constructionjasont is on a distinguished road
Default Using Merge Data to Customize a File Name

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Merge Data to Customize a File Name How do I customize OneNote's file system? gogreen OneNote 1 07-27-2016 09:38 AM
Using Merge Data to Customize a File Name Mail merge result in separate world files instead of one file containing all the data xdhbsh Mail Merge 3 12-24-2015 12:23 AM
Using Merge Data to Customize a File Name Mail Merge Drops Data File Office 2013 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft