Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
I need your help to get rid of the Outlook security message that shows up everytime I use this procedure that shows the Address Book window so that the user can select an email address that will be stored in a textbox for later use. I am attaching the procedure and wonder if another way exist to have the same result and avoid the Outlook security message. Thanks. Karim _______________________________________________ Sub Address(field, shortname, destinataire) Dim olemsg, sDialogCaption, recips On Error GoTo Erreur Set olemsg = CreateObject("MAPI.Session") olemsg.logon "", "", False, False, 0 sDialogCaption = "Sélectionnez " & field If Not Err Then Set recips = olemsg.addressbook(Nothing, sDialogCaption, True, False, 1, shortname, "", "", 0) destinataire = recips(1).Name olemsg.logoff End If Set olemsg = Nothing Set recips = Nothing Exit Sub Erreur: Call Erreur End Sub |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
See
http://www.rondebruin.nl/sendmail.htm or http://www.rondebruin.nl/cdo.htm (no security warnings) Hope this helps. Martin Karim Benabd ha escrito: Hello All, I need your help to get rid of the Outlook security message that shows up everytime I use this procedure that shows the Address Book window so that the user can select an email address that will be stored in a textbox for later use. I am attaching the procedure and wonder if another way exist to have the same result and avoid the Outlook security message. Thanks. Karim _______________________________________________ Sub Address(field, shortname, destinataire) Dim olemsg, sDialogCaption, recips On Error GoTo Erreur Set olemsg = CreateObject("MAPI.Session") olemsg.logon "", "", False, False, 0 sDialogCaption = "Sélectionnez " & field If Not Err Then Set recips = olemsg.addressbook(Nothing, sDialogCaption, True, False, 1, shortname, "", "", 0) destinataire = recips(1).Name olemsg.logoff End If Set olemsg = Nothing Set recips = Nothing Exit Sub Erreur: Call Erreur End Sub |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Martin.
Martin Los a écrit : See http://www.rondebruin.nl/sendmail.htm or http://www.rondebruin.nl/cdo.htm (no security warnings) Hope this helps. Martin Karim Benabd ha escrito: Hello All, I need your help to get rid of the Outlook security message that shows up everytime I use this procedure that shows the Address Book window so that the user can select an email address that will be stored in a textbox for later use. I am attaching the procedure and wonder if another way exist to have the same result and avoid the Outlook security message. Thanks. Karim _______________________________________________ Sub Address(field, shortname, destinataire) Dim olemsg, sDialogCaption, recips On Error GoTo Erreur Set olemsg = CreateObject("MAPI.Session") olemsg.logon "", "", False, False, 0 sDialogCaption = "Sélectionnez " & field If Not Err Then Set recips = olemsg.addressbook(Nothing, sDialogCaption, True, False, 1, shortname, "", "", 0) destinataire = recips(1).Name olemsg.logoff End If Set olemsg = Nothing Set recips = Nothing Exit Sub Erreur: Call Erreur End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add-in AND Macros Not Showing Up in New Book | Excel Discussion (Misc queries) | |||
e-mail address via outlook address book | Excel Programming | |||
Immediate Window not showing up below code window | Excel Programming | |||
How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
How to insert an address from Outlook 2003 address book ? | Excel Programming |