A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

click a button on the toolbar (via VBA?)



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old April 28th 06, 04:17 PM posted to microsoft.public.outlook,microsoft.public.outlook.program_vba
Dan
external usenet poster
 
Posts: 35
Default click a button on the toolbar (via VBA?)

hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send SMS
trhough my local provider. Unfortunately, there is no programmatic (library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook contacts), a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate a
send from there.

is there a way to use VBA to click on a button in the toolbar that does not
expose itself in the library?

thanks

dan


Ads
  #2  
Old April 30th 06, 10:04 AM posted to microsoft.public.outlook,microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default click a button on the toolbar (via VBA?)

Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:

Dan, you could use the CommandBars.FindControl function to get a reference
on that button. For a CommandBarButton you can then call its Execute method,
thatīs similar to a click on that button. But thatīs it. You still need to
do a click somewhere and then enter more information, so I donīt see any
advantage.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send SMS
trhough my local provider. Unfortunately, there is no programmatic

(library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook contacts),

a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate a
send from there.

is there a way to use VBA to click on a button in the toolbar that does

not
expose itself in the library?

thanks

dan

  #3  
Old May 1st 06, 01:03 PM posted to microsoft.public.outlook.program_vba
Dan
external usenet poster
 
Posts: 35
Default click a button on the toolbar (via VBA?)

Thanks a lot for that pointer, Michael.

I found the button with OutlookSpy:
CommandBars.Item("Desktop SMS").Controls.Item("New S&MS")

could you eventually point me to a description on how to do that execute
method? I am not quite a specialist on programming.

thanks a lot

dan


"Michael Bauer" wrote in message
...
Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:

Dan, you could use the CommandBars.FindControl function to get a reference
on that button. For a CommandBarButton you can then call its Execute
method,
thatīs similar to a click on that button. But thatīs it. You still need to
do a click somewhere and then enter more information, so I donīt see any
advantage.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send
SMS
trhough my local provider. Unfortunately, there is no programmatic

(library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook contacts),

a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate a
send from there.

is there a way to use VBA to click on a button in the toolbar that does

not
expose itself in the library?

thanks

dan



  #4  
Old May 1st 06, 01:44 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default click a button on the toolbar (via VBA?)

Dan, I think the page at http://www.outlookcode.com/d/tips/commandbarfun.htm should give you plenty of examples.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Dan" wrote in message ...
Thanks a lot for that pointer, Michael.

I found the button with OutlookSpy:
CommandBars.Item("Desktop SMS").Controls.Item("New S&MS")

could you eventually point me to a description on how to do that execute
method? I am not quite a specialist on programming.

thanks a lot

dan


"Michael Bauer" wrote in message
...
Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:

Dan, you could use the CommandBars.FindControl function to get a reference
on that button. For a CommandBarButton you can then call its Execute
method,
thatīs similar to a click on that button. But thatīs it. You still need to
do a click somewhere and then enter more information, so I donīt see any
advantage.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send
SMS
trhough my local provider. Unfortunately, there is no programmatic

(library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook contacts),

a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate a
send from there.

is there a way to use VBA to click on a button in the toolbar that does

not
expose itself in the library?

thanks

dan



  #5  
Old May 1st 06, 02:39 PM posted to microsoft.public.outlook,microsoft.public.outlook.program_vba
Dan
external usenet poster
 
Posts: 35
Default click a button on the toolbar (via VBA?)

I investigated a little more and found a similar thing on Sue's website at
http://www.outlookcode.com/codedetail.aspx?id=350. I made some changes and
the result is below. However, it does not work. apparently I do something
wrong. the ID as from OutlookSpy is 1, but is 1 for all external COM
add-ins. so I thought I'd would try the statement below..

any idea why there is no ID to be found?


Sub ToggleSMS()
Dim objOL As Outlook.Application
Dim objExpl As Outlook.Explorer
Dim objCBB As Office.CommandBarButton
On Error Resume Next

Set objOL = CreateObject("Outlook.Application")
Set objExpl = objOL.ActiveExplorer
Set objCBB = objExpl.CommandBars.FindControl(, ID:= _
CommandBars.Item("Desktop SMS").Controls.Item("New S&MS").ID)
objCBB.Execute

Set objOL = Nothing
Set objExpl = Nothing
Set objCBB = Nothing
End Sub


"Dan" wrote in message
...
Thanks a lot for that pointer, Michael.

I found the button with OutlookSpy:
CommandBars.Item("Desktop SMS").Controls.Item("New S&MS")

could you eventually point me to a description on how to do that execute
method? I am not quite a specialist on programming.

thanks a lot

dan


"Michael Bauer" wrote in message
...
Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:

Dan, you could use the CommandBars.FindControl function to get a
reference
on that button. For a CommandBarButton you can then call its Execute
method,
thatīs similar to a click on that button. But thatīs it. You still need
to
do a click somewhere and then enter more information, so I donīt see any
advantage.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send
SMS
trhough my local provider. Unfortunately, there is no programmatic

(library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook
contacts),

a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate
a
send from there.

is there a way to use VBA to click on a button in the toolbar that does

not
expose itself in the library?

thanks

dan





  #6  
Old May 1st 06, 03:23 PM posted to microsoft.public.outlook.program_vba
Dan
external usenet poster
 
Posts: 35
Default click a button on the toolbar (via VBA?)

Ah!
Got it. The Lookout sample pushed me into the right direction. Thanks a lot,
Sue. Now I can at least open the form. A pity that there seems no way to
fill in thge address field of that form from the context...

Dan

"Sue Mosher [MVP-Outlook]" wrote in message
...
Dan, I think the page at http://www.outlookcode.com/d/tips/commandbarfun.htm
should give you plenty of examples.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Dan" wrote in message
...
Thanks a lot for that pointer, Michael.

I found the button with OutlookSpy:
CommandBars.Item("Desktop SMS").Controls.Item("New S&MS")

could you eventually point me to a description on how to do that execute
method? I am not quite a specialist on programming.

thanks a lot

dan


"Michael Bauer" wrote in message
...
Am Fri, 28 Apr 2006 16:17:05 +0200 schrieb Dan:

Dan, you could use the CommandBars.FindControl function to get a
reference
on that button. For a CommandBarButton you can then call its Execute
method,
thatīs similar to a click on that button. But thatīs it. You still need
to
do a click somewhere and then enter more information, so I donīt see any
advantage.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


hi there,

I do have a plugin (Red Oxygen Outlook COM Add-In) installed on Outlook
2003. That plugin adds a button to the toolbar which allows me to send
SMS
trhough my local provider. Unfortunately, there is no programmatic

(library)
access to that plugin. The functionality is very primitive. I click the
button and a form opens that allows me to enter a name for the receiver
(that one will be checked against the directory or the Outlook
contacts),

a
text to be sent and that's about it.

There is no way I can see to fire up that form except to click on that
button. I wonder if there might be a way to add some more functionality,
like adding that tool to the right click menu of a contact and initiate
a
send from there.

is there a way to use VBA to click on a button in the toolbar that does

not
expose itself in the library?

thanks

dan





  #7  
Old May 2nd 06, 07:26 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default click a button on the toolbar (via VBA?)

Am Mon, 1 May 2006 15:23:46 +0200 schrieb Dan:


As I told you, youīll get no advantage - except of learning something :-)

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --

Ah!
Got it. The Lookout sample pushed me into the right direction. Thanks a

lot,
Sue. Now I can at least open the form. A pity that there seems no way to
fill in thge address field of that form from the context...

Dan

"Sue Mosher [MVP-Outlook]" wrote in message
...
Dan, I think the page at

http://www.outlookcode.com/d/tips/commandbarfun.htm
should give you plenty of examples.

  #8  
Old May 2nd 06, 10:35 AM posted to microsoft.public.outlook.program_vba
Dan
external usenet poster
 
Posts: 35
Default click a button on the toolbar (via VBA?)


As I told you, youīll get no advantage - except of learning something :-)


and learning is ALWAYS a good thing.
thanks

Dan



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
click a button on the toolbar (via VBA?) Dan Outlook - General Queries 2 May 1st 06 02:39 PM
Run VBA Code from 'new mail message' on standard toolbar Carmi Outlook and VBA 8 March 31st 06 06:53 PM
Toolbar button to evoke a custom view ? [email protected] Outlook - General Queries 1 March 20th 06 02:30 PM
how do I send a letter without a send button on the toolbar? son Outlook - General Queries 1 February 16th 06 05:57 PM
Toolbar button for show gridlines? [email protected] Outlook and VBA 1 February 14th 06 07:20 AM


All times are GMT +1. The time now is 01:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright Đ2004-2025 Outlook Banter.
The comments are property of their posters.