View Single Post
 
Old 11-26-2019, 07:59 AM
dt27295@gmail.com dt27295@gmail.com is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2019
Location: NC
Posts: 1
dt27295@gmail.com is on a distinguished road
Default Outlook recent files not updated when PDF saved via VBA code

When I save a PDF file in Word using the File - Save As - PDF then go to Outlook and attempt to attach a file, the last file I saved in Word will be shown and is easily selectable. Using VBA, I've automated the process of creating a PDF file each time I save my Word document. But when VBA is used to create the PDF the file does not show in recent files for other applications (MS Outlook specifically)

I'm overriding the FileSave method to both save the native docx and then calling "SaveAs" to create the PDF. The native docx is visible in MS Outlook recent files, but the PDF created from calling "SaveAs" in VBA code is not.

Anyone seen this behavior or know a way to force the addition of the PDF file to the recent files so it's visible in other Office applications?

BTW - I realize I could automatically attach the PDF from VBA but the document is not always emailed so I'm not looking to create an email each time the document is saved but would like it available in the list when ready to email (and to learn a bit more about VBA.)

Thanks,
Dan
Reply With Quote