Archive for the ‘Office’ Category

Office 365 emailing invoices

July 6, 2017

I had a client that wanted this so I looked into it and found the following;

  • Login as an admin
  • Go to Billing
  • Go to Billing notifications
  • Toggle on or off for emailing ALL admins.

Unfortunately at this time there is no way to select which users will get the notifications. It will email ALL admins regardless of their admin role.

Outlook deleted my vCard Signature

June 5, 2017

This drove me crazy!

Outlook would literally delete my vCard files an other files I had in a signature I just created. You know that signame_files folder that goes with the signatures? Yep that folder would have it’s contents deleted except for an image file of the vCard. Not so helpful Microsoft…

You didn’t come here to chit chat so here’s the fix… or at least my work around!

  • Create the signature exactly the way you want it.
  • Add in any image files for text and the vCard.
  • Make sure that all your reply options are set.
  • Close Outlook.
  • Now open %appdata%/Microsoft/Signatures
  • Change the properties for all the .htm, .rtf & .txt files to ONLY allow READ access.
  • For this Right click > Properties > Security (tab) > Advanced > Disable Inheritance > Convert Inherited Permissions… > Double click on the user and remove all permissions except READ.
  • Save and repeat for the folder i.e. if your signature was called “my signature” then you should see a folder called “my signature_files”.
  • Now you can open Outlook and it should have your vCard signature all done.

Can’t edit Programmatic Trust Center

October 25, 2016

If you have a third party  app that interacts with Outlook (such as Encore) and when it requests access you get prompted by Outlook.

For most of the time you can give access either one off or from 1 to 10 minutes at a time but if you need to just drop the prompts (and bear in mind the reason they put this in was for security reasons!) then follow these registry tweaks to allow access WITHOUT prompts.

You’ve been warned re the security so on with the show;

Open the registry  editor and navigate to;

HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\XX.X\Outlook\Security

You’ll most likely need to create these entries and change their values to 2 for AutoApprove;
Dword: PromptOOMSend
Value: 2
Dword: PromptOOMAddressBookAccess
value: 2
Dword : PromptOOMAddressInformationAccess
Value: 2
Dword: PromptOOMMeetingTaskRequestResponse
Value: 2
Dword: PromptOOMSaveAs
Value: 2
Dword: PromptOOMFormulaAccess
Value: 2
Dword: PromptSimpleMAPISend
Value: 2
Dword: PromptSimpleMAPINameResolve
Value: 2
Dword: PromptSimpleMAPIOpenMessage
Value : 2

You will won’t be able to edit the options but it won’t prompt you anymore…

 

 

 

Credit :

HARVEYY [https://social.technet.microsoft.com/profile/harveyy%20-%20msft/?ws=usercard-mini]

https://social.technet.microsoft.com/Forums/office/en-US/e2c89fec-beb3-4224-a6cb-112704406907/cannot-change-programmatic-access-security?forum=outlook

Office files won’t open from a shared drive but DO if copied locally

February 1, 2016

Weird would be a good word here…

Anyway long story short (as always) it was caused by corruption in the OFFICE profile – location found below.

Just rename the office folder – of course making sure you don’t have any office apps open at the time.

  • Rename %APPDATA%\Local\Microsoft\Office to something like Office.old.

Open Word (or Excel, etc.) by it’s self (not loading a file) and then close the application.

Then go open that pesky network file and it should fix it.

 

Word 2010 keeps asking to save Normal.dotm

March 18, 2014

This isn’t something I come across everyday so I know I’ll forget it. Also when I look at the advanced options under File and then the Save categories, “Prompt before saving Normal Template” is already unchecked!

Here’s the fix;

  • Click on the File Tab
  • Then Options
  • Add-Ins
  • At the bottom click the COM Add-ins
  • Uncheck the Send to Bluetooth option

Outlook font sizes (2010)

November 26, 2013

So there are two places to do this; The main screen where it shows your inbox etc and then also when composing emails.

To change the first setting do this;

  • Select View > Current View > Customize Current View
  • Click Other Settings….
  • Click on Row Font….
  • Choose the font, style & size.
  • Click OK.

For the second (inside a new email) it’s even easier;

  • Open a new email and look for a magnifying glass in the top right hand side.
  • It’s a Zoom function!
  • Click that and then change the 100% to what ever you want.

Simple. Easy.

Auto CC in Outlook.

May 21, 2013

In Outlook 2010 (but most likely other versions will work the same) open up Rules as NEW rule, not a rule based on an email. To do that;

  • Click on the arrow next to the Rules button on the Home tab.
  • Choose “Manage Rules and Alerts“.
  • Click “New Rule“.
  • Under “Start from a blank rule” choose “Apply rule on messages I send“.
  • Click Next.
  • Click Next. (and Yes I know it will apply to every message, sheesh)
  • Check the box for CC the message to people or public group.
  • In the Step 2 box click on the people or public group link.
  • In the “To – >” field just type in your email address or choose from your address book.

Turn off Autodiscover for Outlook

April 22, 2013

Moved a client from an onsite Exchange server to a cloud based Exchange server ( Office 365 ) and had the constant problem of Outlook ignoring what I had set as the server address and instead looking for the Local Exchange server.
In the end the good folks at Office365 pointed me toward a registry hack to stop Outlook from ignoring what I had set… thanks MS…

Open regedit and go here (where nn is the version you have);

  • HKEY_CURRENT_USER\Software\Microsoft\Office\nn \Outlook\AutoDiscover

Then create a DWORD called ExcludeScpLookup and give it the value of 1.

Yes, you’re right, if you give it a value of 0 it turns it off again. Great if you’re in the midst of going back and forth to grab data/settings/etc.

Moving Outlook Folders

February 20, 2013

Wow – I had a client with, hmm, maybe 300 folders all on the root of a PST file. When I moved them to Office365 they had an Archive option with UNLIMITED space! Woohoo! So now to move those 300 folders to the Archive…. Boooo!

At first I was moving one folder at a time because as you may know, you can’t group move or copy folders that aren’t already within a folder themselves. This process was going to take about a week I would guess.
So it struck me that if I move each folder on the PST to another root folder on the SAME PST the move should be instant as it’s not copying data, it’s just changing the pointer of where the data should be inside the PST. So then all I need to do once they are all under one folder is move that root folder to the online archive.

But wait Mr Tipster dude, you have already started copying the folders on the new online archive right?

Oh yes dear reader I did, but the same proces works for the online archive. I just call the folders different names and then when the new PST root folder copied to the online archive, I just did the reverse and moved the folders to where I needed instantly – remember because now that the data is there it’s just a pointer change.

Confused? I know I can sound garbled… so here’s a break down;

BEFORE

LOCAL PST

  • folder4
  • folder5
  • folder6
  • etc

ONLINE ARCHIVE

  • brand new archive folder
    • folder1
    • folder2
    • folder3
    • etc

MID-PROCESS

LOCAL PST

  • new root folder
    • folder4
    • folder5
    • folder6
    • etc

ONLINE ARCHIVE

  • brand new archive folder
    • folder1
    • folder2
    • folder3
    • etc

AFTER

LOCAL PST

ONLINE ARCHIVE

  • brand new archive folder

    • folder1
    • folder2
    • folder3
    • etc
  • new root folder
    • folder4
    • folder5
    • folder6
    • etc

So then all I needed to do was to drag the folders within the ONLINE ARCHIVE folder “new root folder” to the other root folder “brand new archive folder” and hey presto!

Still confused? Go have a drink 🙂

Recover emails from a PST

December 5, 2012

got it from here;
http://www.howto-outlook.com/howto/restoredeleteditemsfromanoutlookpst.htm

But the basic essence, is;

  • copy the PST (for obvious reasons)
  • download a hex editor.
  • blank the positions 7-13.
  • save
  • Scan the pst with scanpst.exe

That’s it. The details are in the link and maybe I’ll flesh this out later on.

Dan