Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




1965 posts

Uber Geek

Subscriber

Topic # 108439 29-Aug-2012 14:13 Send private message

I've put together a custom macro using a small amount of VBScript that just puts a custom toolbar into the Outlook 2010 ribbon with a bunch of links to forms templates in it which is designed to make things easier for people. There's also a calendar cleanup script in there that removes attachments from old emails to save space in their Exchange mailbox.

Now, while this all works perfectly on my machine, as soon as I install the files needed and try using it for someone else, it complains about signing issues.

From what I can see, the only way to deploy this in a universally signed form involves creating a "proper" add-in using the commercial Visual Basic application. There's 2 key problems with this;

a) I'd really like to deploy this without needing to also deploy extra runtime libraries
b) I don't have Visual Basic. (The Express version doesn't seem to support the modules I need)

I've deployed essentially the same thing to Word and Excel with no problems whatsoever, but Microsoft seem to have implemented some arbitrary requirement that prevents me from doing it in Outlook. Has anyone got any bright ideas or am I out of luck?




"You are" = "You're" - Not "Your".  "They are" = "They're" - Not "Their" or "There".  You probably mean "lose" not "loose".  There's no such word as "Alot".
 
On the internet, wasting time, since '89.

Create new topic

gzt

3196 posts

Uber Geek

Subscriber

  Reply # 678885 29-Aug-2012 18:06 Send private message

Are you sure you need VB to sign? Does the self sign tool not come with office?

http://www.howto-outlook.com/howto/selfcert.htm

How many machines do you need to deploy to? Other option is an enterprise CA I guess.

[Edit: other option is lowering security to avoid warnings but not desirable]



1965 posts

Uber Geek

Subscriber

  Reply # 679652 31-Aug-2012 11:44 Send private message

Well, ideally I'd want to deploy it firmwide to approx 900 systems.

There is a self-sign tool but it doesn't seem to do it in such a way that it gets around the existing macro security which is fixed by GPO. We've had a 3rd party write a similar tool but despite the fact that it does work (given that it's a "proper" add-in) their implementation is a massive kludge and I don't like deploying it in the way it's been provided. Unfortunately, I've got enough authority to deploy a good alternative, but not enough to get them to do it "properly" due to relative costings.

I might look at seeing if there's a way we can slap a global cert onto it from further up the line.




"You are" = "You're" - Not "Your".  "They are" = "They're" - Not "Their" or "There".  You probably mean "lose" not "loose".  There's no such word as "Alot".
 
On the internet, wasting time, since '89.

gzt

3196 posts

Uber Geek

Subscriber

  Reply # 679722 31-Aug-2012 13:19 Send private message

Yeah, self sign is local system only. No use for 900 machines.

Another option could be buying cert from a recognised authority (one included in the standard windows root certs) if that is a clearer path than using an enterprise CA. Some may have trial certificates so you can see what the effect is.

Do you still get the warning on the system you self signed on? IIUC you should only get the warning the first time it is used on that system (certificate accept).

The only correct way to avoid the warning completely for all users is adding to the trusted publishers list with GPO. Pretty sure your admin could add a self signed certificate to that list if you really wanted to. This can be seen as breaking trust relationships so your admin may not be too keen. Back to an enterprise CA again.

I've done a few things with activex signing and ssl but not heavily involved in office. Hope this helps.

Is there a cert for the developer you mentioned earlier in the trusted publishers list?

Create new topic



Twitter »
Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when new jobs are posted to our jobs board:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:




News »

Trending now »
Hot discussions in our forums right now:

A reason not to shop at dick smith
Created by dsnz1, last reply by AKLWestie on 17-May-2013 22:45 (82 replies)
Pages... 4 5 6


Chorus is cutting the cost of VDSL to service providers from June 7
Created by maxzzz, last reply by Ragnor on 16-May-2013 02:57 (40 replies)
Pages... 2 3


A new project coming to Geekzone
Created by freitasm, last reply by InstallerUFB on 19-May-2013 09:27 (197 replies)
Pages... 12 13 14


HTC One (2013) owners' discussion
Created by Dingbatt, last reply by bmt on 19-May-2013 09:28 (1418 replies)
Pages... 93 94 95


Galaxy S4 to run stock Android, by Google
Created by kiwitrc, last reply by Lambchop on 17-May-2013 02:54 (30 replies)
Pages... 2


Sitting on a boring conference call
Created by SaltyNZ, last reply by SepticSceptic on 17-May-2013 16:52 (14 replies)

Office 365 service outage 2013-05-18
Created by freitasm, last reply by networkn on 18-May-2013 22:31 (12 replies)

Samsung Galaxy SIII Discussion and Owners Thread
Created by networkn, last reply by Johnk on 18-May-2013 14:50 (5522 replies)
Pages... 367 368 369



Geekzone Jobs »
Most recent NZ jobs in technology:

SQL Business Analyst
Posted 19-May-2013 09:27

IT Technician
Posted 18-May-2013 22:27

IT Technician
Posted 18-May-2013 22:27

Office Girl
Posted 18-May-2013 13:27

CRM Lead/ Senior MS CRM Consultant
Posted 18-May-2013 09:27

Business Analyst - Technical Web Focus
Posted 18-May-2013 09:27

Senior Front End Developer
Posted 18-May-2013 09:27


Geekzone Live »
Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.