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: 107
Default Importing from Outlook - how to remove the alert.

I use MS Office 2003 on Win XP

The following is the first few lines of code I'm using to import Outlook
contact information.
It works fine, but I get the standard alert dialog box saying that a program
(my Code) is trying to access addresses stored in Outlook. I allow access for
1 minute and all is well, except I don't need the alert.
Trawling the various knowledge bases suggests that if I use the intrinsic
Application object (not NewApplication) I won't get the alert.
Not so with the code below.
Somewhere else suggested a digital signature was the answer.
I have created a SelfCert signature and applied it to this code.
It is recognised and works, but still I get the alert.

Sub ImportPhone()
Dim olApplication As Outlook.Application
Dim olNSpace As Outlook.Namespace
Dim olJournalFolder As Outlook.MAPIFolder
Dim olJournalItem As Outlook.JournalItem
Dim wbBook As Workbook
Dim wsSheet As Worksheet
Dim lnCount As Long, i As Long

Set olApplication = Outlook.Application
Set olNSpace = olApplication.GetNamespace("MAPI")
Set olJournalFolder = olNSpace.GetDefaultFolder(olFolderJournal)
How can I stop it appearing??
--
donwb
 
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
Can you attach an alert to a date in excel(eg to outlook calendar Total Excel Dunce Excel Discussion (Misc queries) 2 May 31st 07 05:29 AM
Help with importing from Outlook Mel Excel Worksheet Functions 0 March 29th 05 07:41 PM
Importing from Outlook semiaza Excel Programming 3 December 7th 04 10:54 PM
Importing from Outlook semiaza Excel Programming 0 December 7th 04 09:32 PM
Vba - Generating Micr Outlook Alert from excel ajliaks[_28_] Excel Programming 1 October 6th 04 03:51 PM


All times are GMT +1. The time now is 04:11 PM.

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"