|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
January 25th 06, 01:35 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Outlook 2000 - Button to run Macro then open Database
Done all that, but how do I make a new macro appear in the commands list? At
the moment, it just exists as a *.bas file in my personal folder. I tried all the help files to no avail. I did it once, last year, but cannot recall how I did it! "Eric Legault [MVP - Outlook]" wrote: You don't need to create the button with code - just go into toolbar customize mode and select Macros from the Categories list in the Commands tab. Then select your macro in the Commands list and drag it to a toolbar. -- Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Richard" wrote: Does anyone know how I can create a Toolbar button (in Outlook 2000) that runs a macro (I already have the macro) then opens an Access 2000 database on a network drive? All in one click of the toolbar button. Your help with this is most appreciated. -- Richard 
|
| Ads |
|
#2
January 25th 06, 04:44 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook 2000 - Button to run Macro then open Database
Macros have to be stored in .bas modules within the Project Explorer of the
Outlook Visual Basic Editor. They should also be declared as Public (not Private) to be visible in the Commands list. -- Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "David C" wrote: Done all that, but how do I make a new macro appear in the commands list? At the moment, it just exists as a *.bas file in my personal folder. I tried all the help files to no avail. I did it once, last year, but cannot recall how I did it! "Eric Legault [MVP - Outlook]" wrote: You don't need to create the button with code - just go into toolbar customize mode and select Macros from the Categories list in the Commands tab. Then select your macro in the Commands list and drag it to a toolbar. -- Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.) Try Picture Attachments Wizard for Outlook: http://www.collaborativeinnovations.ca Blog: http://blogs.officezealot.com/legault/ "Richard" wrote: Does anyone know how I can create a Toolbar button (in Outlook 2000) that runs a macro (I already have the macro) then opens an Access 2000 database on a network drive? All in one click of the toolbar button. Your help with this is most appreciated. -- Richard
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I open outlook 2000 contacts in outlook 2003? | bisquix | Outlook - Using Contacts | 1 | February 21st 06 05:03 AM |
| Outlook 2000 Inbox button | RwcpasIT | Outlook - Installation | 0 | February 2nd 06 07:00 PM |
| open outlook data files from vbscript / macro? | Mad Scientist Jr | Outlook and VBA | 2 | January 24th 06 11:20 PM |
| Office 2000 Updates removed files and can't open Outlook/Express | Karen | Outlook - Installation | 1 | January 17th 06 04:30 PM |
| VB and outlook macro need help | jbullington | Outlook and VBA | 1 | January 10th 06 04:22 PM |
Linear Mode
