Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts

Friday, February 22, 2013

Changing the outlook 2013 contact card to previous version

Changing the outlook 2013 contact card to previous version



Copy the following text to a notepad, save it as outlook.reg and run it.





Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\15.0\common\contactcard]
"TurnOnLegacyGALDialog"=dword:00000001







To revert, go to registry and change the TurnOnLegacyGALDialog value to 0

Friday, November 25, 2011

Outlook signatures location

Outlook 2010

Signatures (.rtf, .txt, .htm)

Windows 7 and Windows Vista
drive:\Users\user\AppData\Roaming\Microsoft\Signatures

Windows XP
drive:\Documents and Settings\user\Application Data\Microsoft\Signatures



http://office.microsoft.com/en-us/outlook-help/where-does-microsoft-outlook-2010-save-my-information-and-configurations-HP010354943.aspx

Monday, July 4, 2011

Change Office 2007 serial Key

How to Change your Office 2007 Product Key:

1.Click Start -> Run
2.Type regedit in the box and click OK
3.Navigate to the following path:
HKEY_LOCAL_MACHINE \Software\Microsoft\Office\12.0\Registration

Within Registration, there is subkey that may resemble the following:

{30120000-0011-0000-0000-0000000FF1CE}

4.Under Registration, you might find several subkeys that contain a combination of alphanumeric characters. Each key is specific to a program installed on your computer.
Open each subkey to view and identify the Office product version by the ProductName registry entry in the right pane. For example:
ProductName=Microsoft Office Professional Plus 2007

5.Once you have located the subkey that contains the Office product you wish to change the license key for, delete the following registry entries by right clicking on the registry entry in the subkey, click Delete, and select Yes:
DigitalProductID
ProductID

6.Close regedit
7.Start Microsoft Word, Excel, Outlook or another Office application. Office 2007 should now prompt you to enter a new 25 character product key
8.Enter a valid product key, and click OK
9.If prompted to choose your preferred type of Microsoft Office 2007 installation, select Install Now
10.Microsoft Office 2007 should now be updated with your new CD key

Tuesday, October 12, 2010

Excel: convert seconds to minutes

An alternative to maintain your time data integrity ie. if you change the format
would be to use the following formula

=YourCell/(60*60*24)

The division by 60 * 60 * 24 is neccessary
because Excel stores all dates as integers and all times as decimal fractions. Excel takes your value as been a single day or 24 Hour
period eg enter 2 = 2days = 2 24hr periods =2*60*60*24 secs
Times are stored as decimal numbers between .0 and .99999,
where .0 is 00:00:00 and .99999 is 23:59:59

and then format your cells like this;

In the "Format cells" Dialog
Select Custom
In the "Type:" box
Type in "mm:ss"

This should give you the results as Minutes Seconds
Use the format painter to copy the custom formats to
your data range.

Thursday, April 15, 2010

Outlook, auto mark as read after selection

When you select a message in outllok it becomes automatically "marked as read".

You can change some features related to it in:

Tools menu > Options > Other tab > Reading Pane button

You have some available options very self explainable.
Check or uncheck as best fits your requirements.

“Mark items as read when viewed in the Reading Pane”.
You might also want to change the number of seconds in this dialog.
“Mark item as read when selection changes”

Friday, September 25, 2009

InfoPath cannot create a new blank form / InfoPath cannot open the form. To fix this problem contact you system administrator



Infopath cannot create a new blank form
InfoPath cannot open the form. To fix this problem contact you system administrator

If this error occur you need to open infopath and go to

tools menu > form options > security and trust > uncheck "automatically determine security level" > select "full trust"

and it's done!

Tuesday, February 17, 2009

Running macro automatically on excel startup

If you record a macro and save it using the name "Auto_Open", the macro will run whenever you open the workbook that contains the macro.
If you want to save the macro with a particular workbook, open that workbook first.
On the Tools menu, point to Macro, and then click Record New Macro.
In the Macro name box, type Auto_Open.
In the Store macro in box, specify where to save the macro:
To save the macro in the current workbook, choose This Workbook.
To create a new workbook to save the macro in, choose New Workbook.
To save the macro in a hidden workbook that is automatically loaded when you start Excel, choose Personal Macro Workbook.
Note If you choose Personal Macro Workbook, Excel will create and save the macro in a hidden workbook named Personal.xls (if Personal.xls doesn't already exist). In Windows 2000, Personal.xls is saved in the C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLStart folder so that it will be loaded automatically whenever Excel starts. If you want the macro you record and save in Personal.xls to act on a particular workbook, you must also save that workbook in the XLStart folder so that it will also be opened when Excel starts.
Click OK, and then perform the actions you want to record.
On the Stop Recording toolbar, click the Stop Recording button.
If you chose to save the macro in This Workbook or New Workbook in step 4, make sure to save or move the workbook into one of the XLStart folders.

Saturday, July 19, 2008

Scroll wheel doesn't work on Excel 2007

Scroll wheel doesn't work on Excel 2007

solution:
Uninstall mouse and reinstall it.
Update office 2007 and Windows.
Reboot Computer
On control panel, double click on mouse.
after update you should have two wheel tabs.
in one of them you have the option "enable universal scrolling"
click exceptions.
click add and browse.
look for excel path.
example:
"c:\program files\microsoft office\office12\excel.exe"
click ok three times.
test it. it should be ok now.

Monday, April 28, 2008

Call Back a Wrongly Sent Email in Outlook

For Outlook 2003:

Open Sent Items.
Open the sent email then go to Actions menu and click recall this message.
     To replace the message:
               Select Delete unread copies and replace with a new message, then type whatever you want to replace it. You can also see who the recall was succesful for.
     To be notified about the success of the recall or replacement:
              Check Tell me if recall succeeds or fails for each recipient.


For Office 2007/2010:

Open Sent Items.
Open the message you wish to recall
Go to the Ribbon.
In the Actions tab, click Other Actions and select Recall This Message.
Choose Delete unread copies of this message.
To see who the recall worked for, check the Tell me if recall succeeds or fails for each recipient.

Friday, April 18, 2008

Outlook Attach file: "Can't create file"

Quando dou duplo clique no anexo por vezes dá este erro:

"Can't create file : FAX.TIF. right-click the folder you want to create the file in, and then click Properties on the shorcut menu to chec your permissions for the folder.


Resposta:
Utiliza o REGEDIT.EXE e localiza a chave:
My Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Outlook\Security

Altera a chave "OutlookSecureTempFolder", mudando "Temporary Internet Files" por "Temp". Por exemplo:
VALOR ANTIGO: C:\Documents and Settings\ricardosilva\Local Settings\Temporary Internet Files\OLK33\ (pode ser diferente de 33)

VALOR NOVO: C:\Documents and Settings\ricardosilva\Local Settings\Temp\OLK33\
Reinicia Microsoft Outlook.