Display name of outlook current user via excel-VBA

**Alicita** · 02-10-2011, 05:10 PM

Hello! I'm trying to find the name of the current user of outlook.
I'm writing an automated email via excel-VBA, and at the end of the email, I want to write the name of the current user.

I've tried this:

Please Login or Register  to view this content.

But I only get the user name of windows..

And then I tried this:

Please Login or Register  to view this content.

But a big error appears ([colaboration data objects - [MAPI_E_LOGON_FAILED(80040111)])

Is there a simplified way for dummies?

Thank you in advance

**Alicita** · 02-11-2011, 08:05 AM

bump, help?

**snb** · 02-11-2011, 08:23 AM

what username do you want "

Application.username
Environ("Username")
createobject("wscript.network").username

Or do you want the accountname 'user@Alicita.ch'

**Alicita** · 02-11-2011, 08:33 AM

the user name from the e-mail account, the actual name of the sender.

My emails from outlook are sent displaying my full name (Alice XXXX) That's what I want, is it clear? :S

I tried your code, but I don't undestand it, and yields me an error :S

**Alicita** · 02-11-2011, 08:06 PM

bump for help

snb, Thank you for your help. I managed to work with your code, but It returns the user name from windows, which I'm not looking for right now.

**snb** · 02-12-2011, 11:10 AM

What do you get using:

Please Login or Register  to view this content.

**Alicita** · 02-14-2011, 08:41 AM

Hi! Thank you for keep helping me

A popup windows appears "A program is trying to access e-mail addresses you have stored in Outlook"
I click "yes" and in another popup window appears my user name of outlook (the one that I wanted!)

Is there a way to eliminate the first pop-up without the intervention of the user?

Thank you!!

**snb** · 02-14-2011, 08:45 AM

Please Login or Register  to view this content.

1 - return to using Excel 2000
2 - Install the freeware ClickYes

**Alicita** · 02-14-2011, 09:19 AM

well.. thank you anyway

Another question, what about the username from the e-mail account, like getting XXXX (XXXX@mail.com) without the pop-up?

**snb** · 02-14-2011, 09:29 AM

To do what ?

**Alicita** · 02-14-2011, 09:57 AM

display the username from the email account

like display Alice from Alice@mail.com

**snb** · 02-14-2011, 10:22 AM

I thought a messagebox is meant to display something.....
So the code did what you asked for.

**Alicita** · 02-14-2011, 10:40 AM

No! arg.. I didn't explain it well enough! Sorry, english isn't my primary language (evidently)

The pop-up box I don't want is the one asking for permission ("A program is trying to access e-mail addresses you have stored in Outlook")The other one, the MsgBox, that's ok. Now, If I can't display the name without the prompt asking for permission, can I display the user name from the e-mail account? such as displaying Alice when the e-mail account is alice@mail.com

Thank you for your pacience!

**snb** · 02-14-2011, 12:41 PM

As soon as you try to read something from outlook you will get the unwanted question. In an earlier post I indicated how you can prevent that question to pop up.

**Alicita** · 02-14-2011, 02:02 PM

I see, I tought it was only THAT specific case, not everything I read from outlook.

Thank you

Display name of outlook current user via excel-VBA

LinkBack

Thread Tools

Rate This Thread

Display

Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Re: Display name of outlook current user via excel-VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions