Follow by Email

Thursday, December 31, 2015

Free Service doesn't affect Net Neutrality

If you are against FreeBasics of Facebook because of OTT Price or Facebook company or Modi government or as a competitor etc., then this post will not entertain you. But If you are against FreeBasics of Facebook only for Netneutrality please read further. Let us consider facebook as a company without any pre assumption.

Actually Net neutrality is nothing but transparent equal access for all internet data. Definitely it should not mean equal pricing, there can be price variation on various socio-economic reasons. watching an entertainment website and downloading a study material should not be priced equally on data. When we oppose rigidly on free basics and support for equal pricing, then students and knowledge seekers are affected when prices were hiked. There are many baseless rumours like free services will create monopoly, suppress start-ups, price hike and more. However If we are really worried about the operating company, then we should draft a regulation laws instead of banning free services.

Thursday, April 24, 2014

How to generate automatic emails

Automatic emails can be defined as the emails which are sent out without human action. Automated emails help not only to avoid repeated tasks and also ensure the punctuality in email transfer. I can classify it in two types, predefined and dynamic based on nature of email body content.

Tuesday, March 18, 2014

Basic examples for Outlook VBA

This post contains few basic examples for VBA in Microsoft Outlook. To get developer tab visible, File -> Option -> Customize Ribbon -> Developer.

Let see a simple example to send an email. Below is the basic code which will generate and shoot the email. In visual Basic Editor, use ThisOutlookSession or any other user modules.

Private Sub SendEmail()
Dim olObj, mlObj
Set olObj = CreateObject("Outlook.Application") 'declaring object
Set mlObj = olObj.CreateItem(0) 'declaring an email item
With mlObj
.To = "" 'Give your email
.Subject = "Testmail" ' Give the subject
.Body = "Testmail" ' Give the Body
.Send 'command to send the email
End With
Set olObj = Nothing 'Clear the memory
Set mlObj = Nothing
End Sub

Wednesday, February 5, 2014

Send automatic email using VBA

Here I have shared the simple code for sending an automatic email using Macros. It can be excuted in all primary products of the Microsoft. you can send emails to recipient from excel data too. Basically To address, subject and HTMLBody are the apex elements. assign those values and shoot the emails using below simple syntax

Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.to = "" 'To address
.CC = ""
.BCC = ""
.Subject = "Assignment"
.HTMLBody = "Hi"
'.Attachments.Add ActiveWorkbook.FullName (for active book)
'.Attachments.Add ("D:\Book1.xls") (for external book)
'.Display (to see the message window)
'.Save (to save as Draft)
End With
Set OutMail = Nothing
Set OutApp = Nothing

You may face one dificulty when you run the code due to your Outlook security setting. It may ask your acceptance through popup. to avoid such popups follow below steps

For older window versions
Tools menu -> Options -> Security tab
uncheck and save "Warn me when other applications try to send mail as me" check box.

For latest Window versions
File - > Options -> Trust Center -> Trust Center settings -> Programmatic Access
Uncheck and save warning option

In office/secured environment, If you are unable to change the security settings, you can use less equivalent code instead of ".Send"
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"

which means your are executing as manual operation

Friday, November 22, 2013

Online service of Indian Gov

To apply passport
Step 1 Visit and register yourself
Step 2 Login to the Passport Seva Portal with your registered Login Id
Step 3 Click "Apply for Fresh Passport/Reissue of Passport" link.
Step 4 update the required details in the form and submit.
Step 5 Click the "Pay and Schedule Appointment" link on the "View Saved/Submitted Applications" screen then schedule an appointment with your convenient time.
Step 6 Click the "Print Application Receipt" link to print the application receipt containing Application Reference Number (ARN)/Appointment Number.
Step 7 On scheduled time visit the booked Passport Seva Kendra (PSK), along with original documents.

For booking appointments, Online Payment has been made mandatory using any one of the following modes:
Credit/Debit Card (MasterCard & Visa)
Internet Banking (State Bank of India (SBI) and Associate Banks Only)

To apply PAN request to Income Tax Department

To apply voter id to Election commission

To apply visa request to Bureau of immigration

Online service for driving licence

To apply Letter of Intent to NAAC:

Thursday, October 31, 2013

Wikipedia BOT using Google script

This page will guide you to create a basic edit model Wikipedia BOT. As we know wikipedia is an open source online encyclopedia, it also allows anyone or any bot to update the pages. Basically, Wikipedia and all its sister projects use Mediawiki software and the API of Mediawiki is available for developer. so using Google Apps Script and Mediawiki API one can develop wonderful BOT application for Wikipedia.

Saturday, September 14, 2013

Simple template for blogger Aggregator

Aggregator is a application which collects latest blog post from various feeds. There are many aggregator tools which will allow you to built a aggregator with or without voting options. But for which you have to setup a server to host. But If you are eager to have own aggregator without any complex tools and simple with blogger environment, this template is for you. Macrolayer introduces new Aggregator template "Aggregator Titan" exclusively made for aggregating service.