Monday, December 30, 2013

How many have used the feature of Mail Merge?

How many have used the feature of Mail Merge?

I remember the days when we were learning the science of computers in school and Mail Merge was one of the advantages of using a word processor on a computer.

I have been learning about computers since I was 11 years old (yes, I am a kid of the 90's) and I can honestly say that I have never used the feature till date. So, this is what I am gonna do for the new year. I am going to use the Mail Merge feature in Word and going to send out my wishes to all.

Take that...

Friday, December 27, 2013

So here's a solution to a problem...

Problem:

The macros I have written in my MS Outlook have suddenly vanished and don't seem to find it.

Solution 1:
Restart MS Outlook. Funny aint it? Yes. I think 80% of the problems in MS are solved by restarting, be is Windows or Outlook.

Solution 2:

The file VbaProject.otm is located in one of the below folder based on the OS.

Win XP: 
C:\Documents and Settings\%username%\Application Data\Microsoft\Outlook\

Win 8/7/Vista:
C:\Users\%username%\AppData\Roaming\Microsoft\Outlook
Backup:
C:\Users\%username%\AppData\Backup\Roaming\Microsoft\Outlook

So, just take the backup from folder and paste it. Make sure you do you it when Outlook is not running.

Start Outlook.