Add a file to the "Recent Items" listing in Outlook Attachment

[austin3515]

I have an Access program file that manipulates files that are on my network/pc. When I work with an excel file for example, I want to have Access add that file to list of recent Items using VBA. That way, the file that I manipulated in Access is right there in my recent items list so I can easily email it out. I do NOT open the file when it is being manipultated. Assume for example I am having Access export a table to Excel. I want that Excel file to be listed on my recent items,

Has anyone done anything like this?

 

[Micron]

It's not clear if you are referring to the Recent Files list that some Office apps (such as Excel) have or if you mean a list that you're creating as a set of Access table records. If the former, I have no idea - except maybe to iterate over whatever is contained in the Recent Files folder. Can't see how that would be of any use as it would contain everything opened by any app.

 

[austin3515]

Solution from a different message board:
"Hi. I haven't tried this before, but I guess what you may have to do is add a shortcut in this folder: C:\Users\%username%\AppData\Roaming\Microsoft\Wind ows\Recent"

Worked perfectly. I had to search around for the language on creating shortcuts but that was much easier to find.

 

[welshgasman]

Cross posted at https://www.access-programmers.co.uk/forums/showthread.php?t=307565

It is common courtesy to advise that the question has been posted elsewhere, though you did have the courtesy to come back with the solution from the that forum.