Return Function as a String to dictate filepath of email attachment

Hi All,

Trying to send an email with an attachment from the My Documents folder. Due to my networked settings I need to be able to change the file path depending on the specific users device etc, all the file paths will be different for each user etc.

So I have a function that successfully returns my file path in a message box. I need to get that function to return a string so I can use it in my email subroutine

Please Login or Register  to view this content.

The above returns the file path for My Documents in a message box

Please Login or Register  to view this content.

and the above is the code to generate my email with the attachment.

I've tried fiddling around with the function so that it returns a string, not a msgbox but I cant seem to figure it out! Ive tried putting a new dimension and setting as the function return too with no luck!

Any advice? Thanks in advance to all!

You guys are Genius!! Thank you so much!! It was stressing me out I couldn't get that! And you cleaned up the code for the email too... Tal.En.Ted.

Thanks again.