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?