How to create friendly excel popups!

[Scott Huish]

Couldn't you just right click the main folder in Outlook, Click on properties, then Home Page and change the URL there rather than edit the registry?

 

[Hatcheda]

Some people can, but not if your workplace locks you out!
I can't
Many people that work at bigger companies can't. -There was once a security concern long since past.

The work around is straight from MS and is mentioned in the white paper on the topic

 

[hatman]

I would replace

.RefreshStyle = xlInsertDeleteCells

with

.RefreshStyle = xlOverwriteCells

to prevent an error from ocurring when you reach the 257th query (assuming that the workbook is saving itself each time... if it isn't, it desn't matter).

Otherwise, it's VERY promising...

 

[Hatcheda]

hatman - You make a very good point!

 

[Scott Huish]

Some people can, but not if your workplace locks you out!
I can't
Many people that work at bigger companies can't. -There was once a security concern long since past.

That may be true, but it's hard to see the logic that they would block you from changing your Outlook Today page, but will more than gladly let you edit the registry. ???

 

[Hatcheda]

Laptop access is admin, unless booted from network. -Then admin with some restrictions, but not registry.

Outlook access is pulled from exchange server. -Even with full admin this can not be changed using outlook. -This is based on an old security threat whereby hackers exploit the html to access/control/harm outlook.

And yes, makes no sense, but I wont complain about having too much access in some areas!

In either case, I think that removing URL to reset the page is easier than remembering the old path correctly