LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default EXCEL Macro calling on Outlook

In order to sign a form, I am going to Outlook to find the name of the person
who has logged onto the computer.

Set objOutlook = CreateObject("Outlook.Application")
Set NameSpace = objOutlook.GetNameSpace("MAPI").CurrentUser

However, when the code is executed, the Outlook application starts to flash
orange and when clicked, the message about Outlook trying to send email
appears. This is a problem because most people don't know what the orange
flashing button means. Is there any other way to get the name of the logged
on person?

--
Gloriann O'Brien
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calling .net Component from Excel Macro j_koushik Excel Discussion (Misc queries) 0 September 30th 05 06:26 AM
Calling Outlook Macro sgreville Excel Programming 0 October 25th 04 12:03 PM
calling excel macro TommyBoy Excel Programming 0 August 12th 04 10:25 PM
Calling Excel Macro From Vc++ via DDE hari Excel Programming 0 July 6th 04 12:50 PM
calling a dll from excel macro Stefan[_4_] Excel Programming 1 December 12th 03 12:16 AM


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"