Email current user

**Tony Vargo** · 04-26-2010, 03:36 AM

Hi all.

I have some code that sends the contents of a userform to my email address. Is it possible to change the code to email the current users usercode? Here's a copy of my code:

Please Login or Register  to view this content.

Any ideas on this guys?

Thanks a lot,

Tony

**Tony Vargo** · 04-26-2010, 06:50 AM

I think I may have copied to much code in earlier! This is the only part I want to change:

Please Login or Register  to view this content.

I want to change it so instead of an set/fixed email address, it inserts the current users UserName.

Any ideas on this on guys?

Thanks,

Tony

**Kyle123** · 04-26-2010, 06:59 AM

It depends how your emails are set up - I use

Please Login or Register  to view this content.

This will put the logon username before the @ sign - Is that what you are after?

**DonkeyOte** · 04-26-2010, 07:03 AM

One of those things that seems like it should be trivial but in reality is not...

Can we first ask why they need to be the recipient given they are already the sender (ie in their sent items folder) ?

If you're fortunate enough that the NT username is also short hand email address you could use that, to test, in VBE immediate window type:

Please Login or Register  to view this content.

Now create a new mail item in Outlook and type in the resulting value and see if OL resolves for you (ie to your mail account) ... if it does it's still by no means watertight.

In short retrieving the mail address of the current user can be a PITA - using LDAP, Redemption etc... if you google you'll find a few examples.