Tuesday, November 19, 2013

How to use an at&t microcell with MVNO straight talk wireless

Step 1. You need to be an at&t customer and your phone number must be an at&t number.
Step 2. You must activate the microcell on your at&t account.
Step 3. You then add your at&t wireless numbers (every single one in your household) to your microcell. (don't forget the at&t cellular capable tablets, and don't forget your work phone if you have one that uses at&t)
Step 4. Port your number to straight talk - give yourself about a day for this to be finished.
http://www.straighttalk.com/

Once your number is ported over to straight talk, your phone will continue to talk to at&t's network through the microcell.  I spoke to at&t about this and they do not allow you to manage a microcell if you don't have an at&t account.  If you switch over all your phones to straight talk (As I did) you will lose the ability to manage your microcell.  As long as your number does not change and you don't switch carriers your home should continue to provide you with 5 bars of cellular coverage thanks to the microcell.

This same procedure may work for other MVNO carriers that use GSM 850/1900 through at&t.

Confirmed by one of my readers: http://www.h2owirelessnow.com/


Here are some possibilities, gathered from wikipedia.  If anyone has tried any of these, leave a comment.

http://www.airvoicewireless.com/
http://www.blackwireless.com/
http://www.cellularabroad.com/
https://www.consumercellular.com/
http://www.divvymobile.com/
http://www.ghzcellular.com/
http://www.good2gomobile.com/
http://www.h2owirelessnow.com/
http://www.iqcellular.com/
http://www.joltmobile.com/
http://www.phonata.com/
http://www.puretalkusa.com/
http://www.goredpocket.com/
http://www.skyvw.com/
http://www.aiowireless.com/
http://www.net10wireless.com/












Tuesday, July 2, 2013

VBA: Get the contents of a search folder (Outlook 2013)

There's a different way of accessing search folders with VBA versus regular mail folders in Outlook. This seems to be poorly documented online so I thought I'd help out with that.

First, you will need to determine the display name of the Outlook store which contains your search folders.
Use this code to list your stores.


Sub FindYourStore()
    Dim colStores As Outlook.Stores
    Dim oStore As Outlook.store

    On Error Resume Next
    Set colStores = Application.Session.Stores
'You may use Session.Stores as shortcut
        For Each oStore In colStores
            Debug.Print oStore.DisplayName
        Next
End Sub


With the name of the Outlook store, you plug that into the next subroutine. In my case, I was using this routine to parse emails in this folder. This routine will list the subject lines of every email in the designated search folder.


THIS CODE ONLY WORKS WITH SEARCH FOLDERS.


Sub ListSubjectLinesOfEmailsInASearchFolder()
    Dim StoreName As String
    Dim FolderName As String
    StoreName = "myemail@mycorp.com"
    FolderName = "Pending Terminations"
    Dim colStores As Outlook.Stores
    Dim oStore As Outlook.store
    Dim oSearchFolders As Outlook.Folders
    Dim oFolder As Outlook.Folder
    Dim mail As Outlook.MailItem

    On Error Resume Next
    Set oFolder = Session.Stores.Item(StoreName).GetSearchFolders(FolderName)
        For Each mail In oFolder.Items
            Debug.Print mail.Subject
        Next
End Sub

I hope that helps someone else out there.