Email Attachment via Outlook

[stuartgb100]

Hi,

I have a VBA routine that allows a user to paste an email address into A1, and type the full path of a file to be attached into B1.

Is there any way (under Windows 7, not Excel VBA) whereby the user can navigate to their chosen attachment and (somehow) capture the full path & name, and copy it to B1 in the sheet ?

Thanks.

[gmayor]

You can do it from Excel VBA, but not from Windows itself. However Shift + Right Click > Copy as path will copy the full path of a selected file to the clipboard for pasting into Excel.