Auto Forward Outlook 'Sent' Items for Backup

August 6, 2008 10:04 by Ramana

This is third time I'm searching net for Auto BCC from Outlook. Whenever I change my laptop I forget to take the VBA script backup, and search the net again to cook the code as I need. This time I thought of posting to blog so that in future if needed i can pick it faster as well it helps lot other.

kick it on DotNetKicks.com

When I send an email I want a copy to be on GMail, in case if I change my PST or have to search quickly on my sent emails or to keep a backup copy or even to check whether my outlook and Norton have delivered it correctly. Sometimes Nortorn Outbound Email Scanning service won't resolve DNS properly and shows error. If we have sent 2 or 3 mails you won't know which one is delivered and which one is not. So to be on safer side GMail helps me.

VBA Code

Private Sub Application_ItemSend(ByVal MyMail As Object, Status As Boolean)
    Dim objEmails As Recipient
    Dim intRes As Integer
    Dim strBcc As String

    '''' Your Bcc address ''''
    strBcc = "my.sent.item@gmail.com"

    On Error Resume Next

    Set objEmails = MyMail.Recipients.Add(strBcc)
    objEmails.Type = olBCC
    If Not objEmails.Resolve Then
        intRes = MsgBox("Could not able to resolve Bcc address. Do you want to still deliever the message?", vbYesNo + vbDefaultButton1, "Could Not Resolve Bcc Recipient")
        If intRes = vbNo Then
            Status = True
        End If
    End If

    Set objEmails = Nothing
End Sub

Outlook Configuration 

  1. In Outlook open the VBA editor by pressing Alt+F11 or Tools -> Macro -> Visual Basic Editor 
  2. Open the ThisOutlookSession module, by double clicking on it.
  3. Copy the above code and paste it into ThisOutlookSession module
  4. Change the Bcc email address in the code
  5. Save it
  6. Now we need to generate the Digital Certificate:
    • Click the Start button -> All Programs -> Microsoft Office -> Microsoft Office Tools, -> Digital Certificate for VBA Projects.
    • In the your certificate's name box, type a descriptive name for the certificate.
    • When the certificate confirmation message appears, click OK.


  7. To verify the certificate in the Personal Certificates store:
    • Open Windows Internet Explorer.
    • Click on the Tools menu -> Internet Options, -> Content tab -> Certificates -> Personal tab.
    • You will find recently created certificate here


  8. Switch back to Outlook VBA editor (if closed press Alt+F11 in Outlook)
  9. Click on ThisOutlookSession module
  10. Click on the Tools menu -> Digital Signature
  11. Choose the certificate and click Ok
  12. Close the VBA Editor
  13. Close the Outlook it may ask again for saving, click Yes


  14. Reopen the Outlook, while opening it will prompt the 'Microsoft Office Outlook Security Notice'


  15. Click on 'Trust all documents from this publisher' 

That's it! It works smoothly. If you change the code, don't forget to re-apply the Digital Signature. If you like to test or troubleshoot in VBA Editor keep a bookmark (red dot) against a line in the code and send a test mail. Outlook will come to that point and wait. Next press F8 or F5 to continue further. Click on breakpoint (red dot) again to remove the same.

Happy forwarding!!!

 


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Apache Windows .htaccess - Password Protect Parent and Allow Sub Directory

August 6, 2008 08:10 by Ramana

To protect a directory in Apache web server, you need to create two files “.htaccess” and “.htpasswd”. “.htaccess” has to be placed under your designated directory. Once you place “.htaccess” under a directory, all its sub directories will inherit its parent properties. Each folder can have its own “.htaccess” file, if it needs to override or extend its parents’ properties.

“.htpasswd” is for storing Usernames and Passwords. It can be placed in the each directory or at a common place to maintain all logins at one place.

In “.htaccess” file you have to specify the path to “.htpasswd”. To protect a web folder the contents in “.htaccess” will be

AuthUserFile C:\wamp\passwords\.htpasswd
AuthName "This is Hasten secret area"
AuthType Basic
<Limit GET POST>
require valid-user
</Limit>

kick it on DotNetKicks.com  

To create “.htpasswd” file with Usernames and Passwords in it, you can find a utility “htpasswd.exe” under “<Apache’s installation directory>/bin” or you can create them online using Dave Child’s page.

In command prompt navigate to the above directory and type below command
htpasswd .htpasswd a-user-name

It creates “.htpasswd” file under “<Apache’s installation directory>/bin” itself. Repeat the same command to add more usernames. Cut the file from there and paste it under desired place as mentioned in the “.htaccess” – “AuthUserFile”.

If you create with Dave Child’s page, paste the text in notepad and save file as “.htpasswd” in desired directory as mentioned in the “.htaccess” – “AuthUserFile”.

Up to now we have seen password protecting a parent folder. Now by placing the following “.htaccess” file in sub folder will make it unprotected. The contents in “.htaccess” will be

Allow from all
Satisfy Any

That’s it! It’s simple!

Are you facing any problem, let’s do discuss here, post your comment.
Let me know your feedback.


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

ExtJS Tips for GridPanel Row - Marking, Colouring, Focusing & Special Key Event Firing

March 16, 2008 12:31 by Ramana

ExtJs, a powerful library for developing web application. Bit complex to learn & start with, but once you practice some examples it becomes easy. You need to have good knowledge in Object Oriented Programming to extend & implement your own features or controls, and to see power of JavaScript & ExtJS. Working with ExtJs is really interesting!

Here listing some hints that may help you in your programming. Array-Grid example that comes with ext-2.0.2 is modified to demonstrate the same.

  1. Focusing grid on load to activate down & up arrows
  2. Colouring grid rows based on some criteria
  3. Key events (especially Navigation keys) usage in grid with Internet Explorer (IE7) & Firefox
  4. Marking selected grid row with some icon / text color change

The code in action can be seen at ExtJs Array Grid Sample
Same can be downloaded from: ExtJs Array Grid Sample - Source Code (~311 KB since extjs images & base scripts).
Main files that are modified: array-grid.html, array-grid.js & examples.css.



1. To focus the grid.

After rendering the grid
    grid.getSelectionModel().selectFirstRow();
    grid.getView().focusEl.focus();


2. Row colouring

Mainly this is CSS twist with use of getRowClass to change the text color of whole row.
    grid.getView().getRowClass = function(record, index){
      return (record.data.change<0.7 ? (record.data.change<0.5 ? (record.data.change<0.2 ? 'red-row' : 'green-row') : 'blue-row') : '');
    };

getRowClass changes the row CSS properties its applied for, but inside a row each cell element will have its own CSS class again.

In CSS for ‘cell-inner’ we need to set the font color.
    .blue-row .x-grid3-cell-inner{
      color:blue;
    }
    .red-row .x-grid3-cell-inner{
      color:red;
    }
    .green-row .x-grid3-cell-inner{
      color:green;
    }


3. Key Events

While working GridPanel, along with focusing the first row we were in a need of implementing the making of rows selected by user with Left Arrow & Right Arrow, as well they can navigate up & down with Up Arrow & Down Arrow.

The below code works partially in IE. It won’t capture navigational (along with arrows, page up, page down, home, end) keys & some special keyevents. But it works perfect in Firefox. 
    grid.on('keypress', function(e){
      alert(e.getKey());
    });

Whereas ‘keydown’ keyboard event works perfectly in both browsers for all keys. But the e.getKey() in IE won’t get the key code for navigational keys & some special keys. So need to change that to normal “e.keyCode”.

There maybe some property to set in ExtJS like in KeyNav -> forceKeyDown to true to make the getKey & keypress work in IE & FF. Not sure where & how exactly, but now the above quick solution worked without any problem.

So the code will be,
    grid.on('keydown', function(e){
      alert(e.keyCode);
    });



4. Marking Selected Grid Rows

In order to mark the selected rows, experimented on task example provided in ExtJs with Google Gears. Before experimenting used the data.columnName = ‘some value’ to set & gridview’s refresh() to apply. But at a time only a row used to change & previous selected rows used to change back.

In this same Array-Grid example added a new boolean value ‘true - flase’ column as first column ‘Status’. Added a ‘renderer’ to this new column, which sets a css class with empty box image if vale is false / tick mark if value true. Also 2 events, one mouse click and the other keydown event to grid to change the value of particular data element. Here the tricky point is if we change the value of it in store record, then automatically the respective CSS will be applied to it through its ‘renderer’. As said before if we change the ‘data’ in grid it won’t work, we need to apply the change of value in record of the store.

The code & css is 
    grid.on('keydown', function(e){
         if(e.keyCode == 37){
           var rec = grid.getSelectionModel().getSelected();
           rec.set('status', false);
         }else if(e.keyCode == 39){
           var rec = grid.getSelectionModel().getSelected();
           rec.set('status', true);
         }
    });
 
    grid.on('rowclick', function(grid, rowIndex, e){
      var rec = grid.store.getAt(rowIndex);
      rec.set('status', !rec.get('status'));
      grid.getView().focusEl.focus();
    });

    .task-completed, .task-check-over {
         width:16px;
         height:16px;
         cursor:pointer;
         background: transparent url(../images/check.gif) no-repeat center -16px;
    }
    .task-check-over {
         background: transparent url(../images/check.gif) no-repeat center -32px;
    }

The above code in action can be seen at ExtJs Array Grid Sample
Same can be downloaded from: ExtJs Array Grid Sample - Source Code (~311 KB since extjs images & base scripts).
Main files that are modified: array-grid.html, array-grid.js & examples.css.


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Horizontal & Vertical – Bidirectional JavaScript Scroller with Images & HTML Content

March 3, 2008 18:35 by Ramana

kick it on DotNetKicks.com  

Here we are using Moo.fx for Mootools to do the trick of animation effect, inspiration of Fx.Scroll demo.

From Mootools, for this animation the main component is Fx.Scroll & supporting component is Fx.Styles along with  other basic core modules that comes with it when we select the above two & download the script (mootools-release-1.11.js).

Programmatically if you would like to create the scrolling elements then element ids need to be created sequentially “content” + i.

The problem with mootools Fx.Scroll is, if the element is in visible area and/or hidden area is not lengthy enough then it wont move to the focused element since it is already in visible area. So we will be looping through again our content elements to produce the extra elements for scroll effect. Basically the repeated count will be number of elements in visible area plus one. If you are able to see 4 elements at a time then repeat initial 5 elements at the end again.

We can change the direction, stop & start the looping of images or html or mixed elements.

Find it action which describes you more. Its blazing fast & cross-browser.

Source of it for download: Bidirectional JavaScript Scroller (~20 KB)


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5