Update "Recent items" in the Outlook attach file dropdown with Pdf file created using VBA

Tim Kowaleski 1 Reputation point
2020-10-07T22:40:56.123+00:00

Background: The sales group at our company has to create quotes then send them to our customers, via email (earth shattering stuff, i know). When exporting a quote to pdf, it involves 5ish clicks and also typing in the file name (File->Export->Create PDF/XPS Document->Quotes->[Type in file name]->Publish).
To save on all the clicks and to make the file names consistent, I created a macro for word that you click a command button and it gives you an inputbox to enter the quote name and then you click "OK" and you're all done.
Now, this is where I would like some help. So we have our quote created and now we want to send it as an attachment in an email. When composing a message in outlook you have the "Attach File" button which gives you a list of recent files. When I save a quote the old fashioned way, the file will appear in that recent items list. However, when i save it using the macro, the file does not appear in that list. This then requires three clicks to get the file attached (Browse This PC->Quotes->[Select Quote.pdf]).

So my question is, how do i get the recent items list in outlook to update with the file created using the macro export to pdf?

Community Center | Not monitored
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2020-10-07T22:53:48.747+00:00

    Outlook development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=outlookdev
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-msoffice_custom

    --please don't forget to Accept as answer if the reply is helpful--

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.