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

put macro into MS Outlook 2000



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 25th 06, 02:19 PM posted to microsoft.public.outlook.program_vba
David C
external usenet poster
 
Posts: 9
Default put macro into MS Outlook 2000

I have a file *.bas from a reliable colleague. How do I attach it to a
button on a toolbar?
Step 2 is OK - Tools Customize Commands Categories Macro select
but the list of macros in the commands pane is empty.

So how do I do step 1 - add the macro to the list ?
Ads
  #2  
Old January 25th 06, 02:55 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default put macro into MS Outlook 2000

You need to run Outlook VBA and use its FIle | Import command.

--
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


"David C" wrote in message ...
I have a file *.bas from a reliable colleague. How do I attach it to a
button on a toolbar?
Step 2 is OK - Tools Customize Commands Categories Macro select
but the list of macros in the commands pane is empty.

So how do I do step 1 - add the macro to the list ?

  #3  
Old January 25th 06, 03:28 PM posted to microsoft.public.outlook.program_vba
Sachin Sancheti
external usenet poster
 
Posts: 7
Default put macro into MS Outlook 2000

Make sure the subroutine in .bas file is public then you will find it
in the list of macros just drop it on the toolbar.

  #4  
Old January 25th 06, 03:40 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default put macro into MS Outlook 2000

Is this file in the Outlook VBA project? If not then use Alt+F11 to open the
VBA project. Select File, Import to import it. Make sure the macro is a
Public Sub that takes no input arguments. After doing that the macro will
appear for you.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"David C" wrote in message
...
I have a file *.bas from a reliable colleague. How do I attach it to a
button on a toolbar?
Step 2 is OK - Tools Customize Commands Categories Macro select
but the list of macros in the commands pane is empty.

So how do I do step 1 - add the macro to the list ?


  #5  
Old January 25th 06, 06:00 PM posted to microsoft.public.outlook.program_vba
David C
external usenet poster
 
Posts: 9
Default put macro into MS Outlook 2000

Thanks all. Answers worked for me !
Alt F11 to open VB editor. F4 then import from file.

Cheers.

"Ken Slovak - [MVP - Outlook]" wrote:

Is this file in the Outlook VBA project? If not then use Alt+F11 to open the
VBA project. Select File, Import to import it. Make sure the macro is a
Public Sub that takes no input arguments. After doing that the macro will
appear for you.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"David C" wrote in message
...
I have a file *.bas from a reliable colleague. How do I attach it to a
button on a toolbar?
Step 2 is OK - Tools Customize Commands Categories Macro select
but the list of macros in the commands pane is empty.

So how do I do step 1 - add the macro to the list ?



 




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
Outlook put mails from people in contactlist separate folder Malliga Baskaran Outlook - Using Contacts 1 February 22nd 06 12:55 PM
How do I put Outlook information on IPOD? dancemaster40 Outlook - Calandaring 1 February 12th 06 07:04 PM
Outlook calendar ablity to put moon phases Justdialt Outlook - Calandaring 1 January 29th 06 06:29 PM
Outlook 2000 - Button to run Macro then open Database David C Outlook and VBA 1 January 25th 06 04:44 PM
VB and outlook macro need help jbullington Outlook and VBA 1 January 10th 06 04:22 PM


All times are GMT +1. The time now is 08:11 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.