Emailing current user

[Tony Vargo]

Hi all.

I suppose this is an Excel and Outlook question!

Basically, I have a workbook and I want to email the sheet to the current user. I've got most of it working, but when the email appears, I want to automatically insert the current users username into the address bar.

I'm sure its possible but I'm stuck! Any ideas appreciated.

Thanks a lot,

Tony