Click here to Skip to main content
15,891,951 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Update System Project Pin
Richard MacCutchan27-Aug-13 3:56
mveRichard MacCutchan27-Aug-13 3:56 
Questioncan't find project or library Pin
Member 1016442922-Aug-13 23:47
Member 1016442922-Aug-13 23:47 
AnswerRe: can't find project or library Pin
Eddy Vluggen23-Aug-13 2:02
professionalEddy Vluggen23-Aug-13 2:02 
QuestionTrojen in vb6 application Pin
salih198922-Aug-13 18:24
salih198922-Aug-13 18:24 
AnswerRe: Trojen in vb6 application Pin
xcal22-Aug-13 18:54
xcal22-Aug-13 18:54 
AnswerRe: Trojen in vb6 application Pin
Bernhard Hiller22-Aug-13 21:25
Bernhard Hiller22-Aug-13 21:25 
AnswerRe: Trojen in vb6 application Pin
Eddy Vluggen23-Aug-13 2:00
professionalEddy Vluggen23-Aug-13 2:00 
QuestionImport Outlook Contact's email address into Excel Pin
harry.roy22-Aug-13 9:47
harry.roy22-Aug-13 9:47 
I am building a excel macro that simply brings up the Outlook Global Adress book and allows you to select a contact and it puts the contact's email address back into an excel cell (or msg box). The Sub below does two things, first part brings up the name of the person who you select, the second part brings up the email address of the current user.

All I want is to bring up the EMAIL of the person you select (not the current user).

Here is my code:

VB
Sub GetEmailAddressClean()

Dim cdoSession, cdoAddressBook, olkRecipients, objAddressEntry, objEU, objAE
CreateObject ("MAPI.Session")
Set cdoSession = CreateObject("MAPI.Session")

cdoSession.Logon "", "", False, False
Set olkRecipients = cdoSession.AddressBook(, "Global Address List", 0, False)

'***********************************************************
'*************** Display Selected Outlook Name *************
'***********************************************************

    For Each objAE In olkRecipients
        MsgBox objAE.Name
    Next

'***********************************************************
'************** Display Email Address **********************
'***********************************************************

    With CreateObject("MAPI.Session")
        .Logon "", "", False, False, 0
        MsgBox .GetAddressEntry(GetNamespace("MAPI").CurrentUser.EntryID).Fields(&H39FE001E).Value
    End With



'***********************************************************
    Set olkRecipients = Nothing
    cdoSession.Logoff
    Set cdoSession = Nothing

End Sub

AnswerRe: Import Outlook Contact's email address into Excel Pin
Chris Quinn22-Aug-13 23:15
Chris Quinn22-Aug-13 23:15 
GeneralRe: Import Outlook Contact's email address into Excel Pin
BobbyStrain28-Aug-13 15:05
BobbyStrain28-Aug-13 15:05 
GeneralRe: Import Outlook Contact's email address into Excel Pin
harry.roy5-Sep-13 4:08
harry.roy5-Sep-13 4:08 
AnswerRe: SOLVED!!! Pin
harry.roy3-Oct-13 9:30
harry.roy3-Oct-13 9:30 
GeneralRe: SOLVED!!! Pin
BobbyStrain4-Oct-13 5:35
BobbyStrain4-Oct-13 5:35 
GeneralRe: SOLVED!!! Pin
harry.roy4-Oct-13 5:42
harry.roy4-Oct-13 5:42 
QuestionHow to build a number to word translation system using console application in visual basic 2008? Pin
Member 1022469021-Aug-13 21:43
Member 1022469021-Aug-13 21:43 
AnswerRe: How to build a number to word translation system using console application in visual basic 2008? Pin
Tim Carmichael22-Aug-13 1:24
Tim Carmichael22-Aug-13 1:24 
AnswerRe: How to build a number to word translation system using console application in visual basic 2008? Pin
TnTinMn22-Aug-13 16:00
TnTinMn22-Aug-13 16:00 
QuestionObjectListView cell contents changing Issue Pin
Pasan14819-Aug-13 18:29
Pasan14819-Aug-13 18:29 
SuggestionRe: ObjectListView cell contents changing Issue Pin
TnTinMn20-Aug-13 5:36
TnTinMn20-Aug-13 5:36 
AnswerRe: ObjectListView cell contents changing Issue Pin
Bernhard Hiller20-Aug-13 21:26
Bernhard Hiller20-Aug-13 21:26 
Questiondisplay images from a database as windows explorer Pin
Member 928309113-Aug-13 9:13
Member 928309113-Aug-13 9:13 
AnswerRe: display images from a database as windows explorer Pin
Eddy Vluggen14-Aug-13 6:11
professionalEddy Vluggen14-Aug-13 6:11 
QuestionNew to WPF. Getting frustrated Pin
beastmp1313-Aug-13 6:34
beastmp1313-Aug-13 6:34 
AnswerRe: New to WPF. Getting frustrated Pin
xcal13-Aug-13 7:03
xcal13-Aug-13 7:03 
GeneralRe: New to WPF. Getting frustrated Pin
beastmp1313-Aug-13 7:12
beastmp1313-Aug-13 7:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.