Add a file to the "Recent Items" listing in Outlook Attachment (1 Viewer)

austinp3515 · Oct 25, 2019

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 · Oct 25, 2019

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 · Oct 27, 2019

Worked like a charm, thanks!!!

Gasman · Oct 27, 2019

theDBguy said:
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 · Oct 27, 2019

austinp3515 said:
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.

Add a file to the "Recent Items" listing in Outlook Attachment (1 Viewer)

austinp3515

Registered User.

theDBguy

I’m here to help

austinp3515

Registered User.

Gasman

Enthusiastic Amateur

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread