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

[austinp3515]

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?

 

[theDBguy]

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\Windows\Recent

Good luck!

 

[austinp3515]

Worked like a charm, thanks!!!

 

[Gasman]

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\Windows\Recent

Good luck!

theDBguy,

FYI the o/p had crossposted at https://www.mrexcel.com/forum/micro...-recent-items-listing-outlook-attachment.html

However he did mention your solution.

 

[theDBguy]

Worked like a charm, thanks!!!

Hi. Glad to hear you got it sorted out. You might consider posting your solution in case it helps someone else. Good luck with your project.