Hello!

I am here again today with another introductory post. Hope you are enjoying the series and using the information shared here. Today, I will introduce Macro for Microsoft Office Outlook. This is interesting, as we would all like someone to check our daily emails, put those emails into different folders, sort them on our requirements and probably compose and email a reply to the sender with the adequate information. Yes, all these are possible in Outlook itself and whatever is not already present, can be achieved using a bit of VBA coding or using Macros. Macros in Outlook are fascinating and today I will show you a simple macro which will tell you when an email lands up in your mailbox.

Open Outlook and Hit Alt + F11 to open the VBA Editor. This is what you do to open the editor in any Microsoft Office Application. Once in the editor, add a new module and type in this text below:



Sub MsgAlert(NewMail As Outlook.MailItem)
MsgBox "You have got a Mail."
& vbCr & "Subject: " & NewMail.Subject & vbCr & "From: "
& NewMail.SenderName & vbCr & vbCr & "It Says:- " & vbCr
& NewMail.Body, vbInformation, "Attention!"
End Sub


This will tell you with a message box telling about the new email that has landed in your inbox with fields like, Subject, Sender Name and the Content of the email. Now, you may add a rule to call this Macro or just modify an existing rule to incorporate this script. To know about Rules and Alerts in Outlook, visit this link.

Macros in Outlook can also be used to automate any task that you perform over and over again. Like sending an End of Day Report Notification or may be responding to specific email lists etc.

To know more about Codes in outlook, you may also visit this exciting website:

http://www.outlookcode.com/

Do let me know how it went. Till then, cya!

I am here today to give you a heads up about VBScript. What are VBScripts? As the name suggests, this is a script version on Visual Basic or VB. We can hence say that Visual Basic Script is a subset of the Visual Basic language.

VBScript is also a scripting language that can be used as an alternative to Java Script that runs in Internet Explorer for Windows OS. What is the relation between Internet Explorer, Windows Operating System and VBScript? Yes, you guessed it right. It is a scripting language supported freely on Windows OS and IE, and all of these are developed by Microsoft. Hence, you can see that VBScripts work only on a Windows hosting platform.

One advantage with VBScript for those who are already familiar with Java Scripts is that VBScript and Java Script blocks can be used together in one document, and functions, statements and variables in these blocks can be related to one another.

The applications written using VBScript are saved as .VBS files that can be executed with either WSCRIPT or CSCRIPT. These two are nothing but Windows Scripting Host programs. VBS applications can execute on computers where Microsoft Windows OS is installed, using these Windows Scripting Hosts.

To know more about VBScripts, feel free to visit the Wikipedia Link. It gives you good insights about the language, its history and much more.

Try this simple code. This will give the squares of first five digits:
Paste the following codes in between < type="text/vbscript"> and < /script >

Dim sText(5)
For i=1 To 5
sText(i)="Square of " & i & "is: " & i*i
Next

For i=1To 5
document.write(sText(i) & " ")
Next

Simple huh! If you want to see a bit more complicated one with some user interface, just replace statement 8 above with the following statement. It asks for 5 phrases one after the other and once you input them, they will show the result in a list.

sText(i)=inputbox("Enter Phrase # " & i)

Try this with names of books, friends or anything that you want and see VBScript in business.

PS: You may add a tag <> at the top and < /html > at the end and save the file as a html file and run it using Internet Explorer. This also works that way. Let me know you are reading. Do comment in your views...

...

First of all, let me tell you that this post is relevant only to the users of Avaya and one who has not used the machine or the software associated with the same may find all this Greek.

A lot of people who use Avaya Call Management System in their day to day life to extract Avaya Telephony data would know the pain involved in extracting data on half hourly, hourly, daily or weekly basis for each split skill they are involved in. If one needs to extract hourly data for a week’s period for 10 split skills, it would mean login into Avaya and after selecting the right view set, one would put in split skill info 24 × 7 × 10 = 1680 times to extract as many dumps. This, considering you need to put only one variable in your query while extracting data.

Just think of a situation, where you are having lunch and someone is extracting the data and saving the dumps with a right naming convention in your computer. You come back and see all the data there – all you need to do is to consolidate those and se the report that you want to. And if you have another macro for consolidating the dumps the way you want, that would be more like it!

Well, while consolidation of data needs to be done on our own, extraction of data is possible with Avaya Scripting. Avaya provides an option to extract and save the dumps based on auto generated scripts. Depending on the view sets chosen and the types of data needed, Avaya generates a script on its own while extracting the dumps. If this script is saved and run at a later stage, the same dump will be extracted, generated and saved in your local computer. All this without having to login to Avaya CMS and putting the variables manually!

This introduction to Avaya Scripting does not have the scope to tell about the same in more details; however, watch this space for more on Avaya, Avaya Scripting and the tweaks that would be necessary to achieve complete automation of Avaya. We will explore more into Avaya and everything that is possible with Avaya Scripting.

Stay tuned!

Welcome. Microsoft Office includes a wide range of Applications that can be used for a wide range of activities required in your daily life or at work. There are many office tools available to an user – few that are free and lots that are not; however, MS Office has grown and maintained their usage and popularity among users all over the world.

Well, this blog is not an agency to promote MS Office in any way, but to re-iterate, we will be talking about codes and scripting which would find their extensive use in these office applications. So, why not start with a small introduction to the same. This is where the codes we discuss in the blog will find their use. Most of the readers of The Code Point would know about MS Office and its basic applications. We can assume it correctly as because if the user have not used it earlier, he would not find the need of searching for codes that are required in these applications. Anyways!

Microsoft Office comes with an online resource of free training which talks about basics of these Office Apps and shows a way to the reader where he can walk on. I have myself used these tutorials many a times, while using MS Word 2003 and MS Excel 2003 and more now, when we are working on MS Office 2007. Feel free to visit the following web link and go through the various free training courses. These courses are self paced and talks about almost all necessary amendments and dissimilarities of an old and new version of MS Office App.

The link: Microsoft Office Training – Microsoft Office Online

Note: If you want something more in those training courses apart from what is listed in the front page, please use the ‘Search Training’ tool at the top of the page.

Well, I was going through a lesson sometime ago and I really loved the way they told about ‘Nested Loops’ used in VBA. Check the following:

Do While (Earth Revolves around the Sun)

    Do While (Earth Rotates around its axis)

        If (Facing Sun) Then

            Day

        Else

            Night

        End If

    Loop

Loop

Quote: OK, so the code above wouldn't actually run in Excel, but it illustrates that for each big loop (around the sun) there are 365 smaller loops (around Earth's axis).

How easy to understand and simple is that? I just loved it. Teaching has to be thus. Simple, easy and to the point! This is the reason I would recommend the reader to go through the material there in free time (even if you consider yourself to be advanced and have no time) and I am sure you will see things that might have missed your eyes!

Best of Luck!