Saving attachment location to Access table using VBA

[RMcCallan]

Hopefully this is the right forum to post this in... if not please point me in the right direction. I figured it was more of an outlook automation issue rather than a vba issue. I have some code which saves emails into a database, creates new folders for new senders etc etc but what I now want to do is when a new email comes in, i want any attachments to be saved into a table (by saving the location and then having the ability to go back in and open it from that location)... All I really need is the code which will show the filepath... does anybody know how to do this? Any replies appreciated.

Thanks,
Rebecca