Solved

Outlook 2011 - Developer Tab

Posted on 2010-11-22
27
2,170 Views
Last Modified: 2012-05-10
I have enabled macros in the general office 2011 applications but am struggling with outlook.  What is the key sequence to enable macros (developer tab) in outlook 2011?

Chris
0
Comment
Question by:Chris Bottomley
  • 13
  • 13
27 Comments
 
LVL 70

Expert Comment

by:KCTS
ID: 34194793
Do you mean outlook 2010?

Go to File->Options->Customize Ribbon

Make sure ALL TABS is selected on the right hand panel, then tick the Developer check box
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34194809
Nope

I mean 2011 i.e. Mac version

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34195462
Hi, Chris.

I don't have a Mac, so I'm going off things I've seen.  Is there a sprocket-like button at the right end of the ribbon?  If so, select it and see if there is an option for ribbon preferences.  If there is, then I'm told it should have an option for enabling the developer tab.
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34224381
David

Apologies... I thought i'd replied.  No that doesn't do it it's finding the ribbon preferences that is visible in the other applications that is part of the problem.  The preferences does not have a ribbon customisation for the developer tab ...unlike the other apps.

Still looking!

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34229918
No worries, Chris.

Is there a gear icon at the top right of the ribbon?
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34230189
Nope nothing of the sort, the other apps yes, outlook no.

Chris
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34230208
BTW

SAVANT, I missed the event so my congrats to you

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34230389
Thanks, Chris.

I'm trying to find someone who uses a Mac to answer the question.
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34230456
Be great if you can.  I am tending to their not supported in 2011 but there are a few web references that say it is a simple edit of the ribbon.

My experience so far though is that they're mistaken and assuming the same mechanism as applies to the other applications in 2011.

I would love for that to not be the case though!

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34230634
I see the same references (i.e. that it's a simple ribbon edit).  Like you though I can't find any specific instructions on how to do it.  I sent a message to the Outlook MVP group asking if any of them know how.  I know some of them have Macs.  Only one response so far from a non-Mac user who said to look for the gear icon.

What version of Mac office do you have (i.e. full version, education version, etc.)?  Don't know that makes any difference, I'm just hedging.
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34230761
Version 14.01 (101012)

Outlook for Mac 2011

Chris
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34230776
Ah the MVP group ... nice to belong - I would imagine!  I'm told that a lot of them use Macs, but it may well be they all use a windows virtual machine and therefore normal PC versions of Office - but it has to be a great forum to ask the question of.

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34230893
A good bit of the chatter on the group is off-topic.  Some of it is way over my head (e.g. professional development issues).  But it is nice to have access to all the top experts in the field.  I know a couple of them are die-hard Mac users.  I'm hoping one of them can answer the question.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34267974
I have seen a reference to outlook 2011 from an MS MVP which says no VBA in outlook 2011.  I have just thought about rules and looked for the option to run a script ... its there - sort of.

You can run an apple script as part of a rule but no sign of any other script capability so it really is looking increasingly likely that the answer is no

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34270566
I didn't get any useful responses from the MVPs.  I see references like those in these articles which say that VB is back in 2011, although none say specifically that Outlook has the capability.  It seems incredible, although clearly not impossible, that Microsoft would have added VB to the other Office apps and not Outlook.

http://www.pcworld.com/businesscenter/article/189123/microsoft_announces_office_for_mac_2011.html
http://www.addictivetips.com/microsoft-office/outlook-2011-for-mac-review-with-screenshots/
http://www.pcmag.com/article2/0,2817,2369733,00.asp
http://win.downloadatoz.com/news/279,microsoft-office-2011-for-mac-supports-for-exchange-vba-20100519.html
http://www.macwindows.com/Outlook-2011-review.html
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 34270634
0
 
LVL 59

Author Closing Comment

by:Chris Bottomley
ID: 34270681
A bit tacky in that there has not been a definitive statement regarding the existence of VBA in outlook.  All indications point to the lack thereof so it is the right interpretation to make.

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34270711
I agree.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34271833
Stand by.  I've posed the question to one of the product managers at Microsoft.  I should have an answer on Monday.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34285099
The answer's back.  Outlook 2011 does not support VBA.  It does support AppleScript.
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 34286136
Thanks for that update ...at least we have what amounts to a definitive answer ... which confirms my impression of http: 34267974

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 34286238
You're welcome, Chris.
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 36200728
David

I have just spent a few hours on trying to program a 'macro' on 2011.  FWIW I can state I have created a script that works on outlook and it is indeed applescript ... but for me it's a practical example of your response from the MS Product Manager.

I now need to see what reference documentation is available because it took me a lot of searching to find enough clues to do some real work.

TTFN!

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 36220742
Good morning, Chris.

I've sent a message to the Outlook MVP group asking if anyone knows of any sites that have reference material and/or practical examples of automating Outlook 2011 using AppleScript.  I'll let you know what the results are once they're in.

Cheers!

David
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 36220914
That wasn't the purpose of my post so ta muchly never even considered that approach!

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 36221062
Here's the first response.

Have you checked the Dictionary already?
 
AppleScript Editor-> File-> Open Dictionary…-> Microsoft Outlook.app
 
There are also a couple of AppleScript mailing list archives which sometimes list some code (but mainly discuss limitations).
http://host171.hostmonster.com/pipermail/scriptoutlook_officeformachelp.com/
http://lists.apple.com/archives/applescript-users
0
 
LVL 59

Author Comment

by:Chris Bottomley
ID: 36221145
No in a word didn't know about it :) but will check when I get home ... Makes sense though as I found out how to call the scripts in olk and there is consistency in that.

Chris
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now