Outlook Macro - Dealing with New Mail and Reminders

Just for the record, in Outlook VBA > ThisOutlookSession:

'' Move Outlook to top when new mail arrives
'Private Sub Application_NewMail()
'    Outlook.Application.ActiveWindow.Activate
'End Sub



'https://www.tachytelic.net/2017/10/how-to-run-a-vba-macro-when-new-mail-is-received-in-outlook/
Option Explicit
Private WithEvents inboxItems As Outlook.Items

' declare this object withEvents displaying all the events
Private WithEvents olRemind As Outlook.Reminders
Dim ReminderAccount As String


Private Sub Application_Startup()
  Dim outlookApp As Outlook.Application
  Dim objectNS As Outlook.NameSpace
  
  Set outlookApp = Outlook.Application
  Set objectNS = outlookApp.GetNamespace("MAPI")
  Set inboxItems = objectNS.GetDefaultFolder(olFolderInbox).Items
End Sub


Private Sub inboxItems_ItemAdd(ByVal Item As Object)
On Error GoTo ErrorHandler
Dim Msg As Outlook.MailItem
Dim MessageInfo
Dim Result
If TypeName(Item) = "MailItem" Then
'    MessageInfo = "" & _
'        "Sender : " & Item.SenderEmailAddress & vbCrLf & _
'        "Sent : " & Item.SentOn & vbCrLf & _
'        "Received : " & Item.ReceivedTime & vbCrLf & _
'        "Subject : " & Item.Subject & vbCrLf & _
'        "Size : " & Item.Size & vbCrLf & _
'        "Message Body : " & vbCrLf & Item.Body
'    Result = MsgBox(MessageInfo, vbOKOnly, "New Message Received")

    Outlook.Application.ActiveWindow.Activate

End If
ExitNewItem:
    Exit Sub
ErrorHandler:
    MsgBox Err.Number & " - " & Err.Description
    Resume ExitNewItem
End Sub



' Dismisses Reminders based on Accounts, before they appear. This works together with Private WithEvents olRemind from top of the code.
Private Sub Application_Reminder(ByVal Item As Object)
    Set olRemind = Outlook.Reminders
    ReminderAccount = Item.Parent.Parent
End Sub

Private Sub olRemind_BeforeReminderShow(Cancel As Boolean)
    Dim objRem As Reminder
    For Each objRem In olRemind
                If objRem.IsVisible And ReminderAccount = "TLaw@solomonpage.com" Then
                    MsgBox ReminderAccount
                    objRem.Dismiss  ' dismisses reminder
                    Cancel = True   ' takes out the reminder window
                End If
                Exit For
        Next objRem

End Sub
Posted in Technical | Leave a comment

Vocab: Capricious

Kathy’s Word of the Week (3/12/2018)

Weekly Brain Food brought to you by our VP of HR

capricious

Pronunciation:
ca-pri-cious

Definition:
Given to sudden and unaccountable changes of mood or behavior

As used in a sentence:
Lady luck is a capricious mother who, as in a recurrent nightmare, always offers, never comes through, and never stops smiling.

Posted in Vocabularies | Leave a comment

Matching Gift is Unethical

I was about to donate $100 to Alliance Defending Freedom, seeing some good work they do, via Janet Mefferd's platform, until I see this $2,000,000 matching gift.

2018-03-08 Matching Gift Alliance Definding Freedom

So, I figure that obviously someone is willing to give $2,000,000 and it's not as under fund as they claim.

What they should do, is just tell whoever it is to give his/her $2mil and stop playing games. This game only fools the simpleton givers. I can find better use for my money else where, after all, I must distribute wisely what was given me, to something that can truly stand firm before God, even against mammon.

Here an idea, can I also become a match gifter, I'll double anyone's giving up to $20. In fact, let's make it so that anyone can enroll as a match gifter with any amount. How that sounds is exactly how I think of matching gifts.

Posted in Theologization | Leave a comment

Vocab from SPG: redolent

Kathy’s Word of the Week (3/5/2018)

Weekly Brain Food brought to you by our VP of HR

redolent

Pronunciation:
red-o-lent

Definition:
Strongly reminiscent or suggestive of something

As used in a sentence:
Their pubs bear names redolent of the monarchy.

Posted in Vocabularies | Leave a comment

Correcting Redeemer/Sermon: The Beginning - 3/4/2018 on Marriage

Preached by Rev. Drew Sokol.

Scripture Reading: Ephesians 5:21-33

First, I should say that Drew was my favorite, even more than Tim Keller. But this second time that I hear him preach, it's like whatever training he's receiving from Redeemer degraded him. He start to quote more books than scripture (a typical Redeemer move), disconnected points, not quite expository.

I'm not sure who picked this passage, but verse 21 does not connect with verse 22 under Marriage. That's why after emphasizing equality of genders in 21, a big mistake, Drew couldn't expound on the following verses from the context of wife & husband. Like Ab Cho, the attention is on any words that has to do with love, give, etc. Might as well remove the words "wives" and "husbands" and replace them with "people".

Drew got one interesting point though, that Biblical dating would have to be an arranged marriage. But I couldn't tell if he assumed that it was a bad thing or not. Because it shouldn't. This is always something common of emergent churches that shout social justice. That they do not understand "the will" to love. It's always about how to create the emotion to love, not far from secular view of love.

My wife noted that East Side's evening number has dropped 1/3 since Tim Keller's "hiatus".

I can only pray for Drew, my favorite preacher of Redeemer. Still...I hope.

I will try to do my on devotion on these sermons and passages. I feel I just had to. Too bad that it's hard to find food easily in this post modern West. Those with degrees, like professors in colleges today, don't really do their jobs, so that there's no difference between doing self study at home and going to class, in fact, sometimes due to unnecessary assignments, colleges waste not only money but time as well. But for the sake of my love for my God, I'll do the extra work. Knock on wood, for those free/cheap online courses.

Interesting that the earlier BCCC (second visit) sermon and Redeemer's topic today has to do with gender. BCCC's Pastor Andy incorrectly (I think) pointed out that the synagogue separated men & women, something I learned from David Croteau's book "Urban Legends of the New Testament: 40 Common Misconceptions". But I do appreciate Pastor Andy's (Despite his confusing between being serious and acting hip) stand on Complementarianism view and boldness in expounding on verses Redeemer, though as a PCA church, was too impotent to handle in public (unless it can be hidden in books).

I might just call the series for these entries "Correcting Sermons" instead of Correcting Redeemer.

I may sound a little angry, but it is an reaction towards impotence in churches.

Now onto the reading: Ephesians 5:21-33

Verse 22 is for the whole congregation, not for husbands and wives. Submit to one another out of the fear for Christ. It concludes a section. But speaking of submission, there is gender distinction, especially when it comes to marriage. Pastor Andy would agree, that we have too much gender confusion today. I really really really don't get where Redeemer truly stands on this, I know they could score 100% on a test given by Pastor Andy on this subject, but that still won't tell me what I wanted to know about Redeemer.

God created Man and Woman. A faithful Christian (dare I use the word "servant" of God? oooo!) should learn the difference. Does that mean that wives are unable to dominate their husbands, women are unable to beat guys at their own games? Of course not. Just the same that a child can kill their parents. Heard of Oedipus Complex? So, if one could solves Oedipus Complex in a harmless, loving & peaceful way, but Oedipus nonetheless, then it's a good thing? Where do you get this from? John Lennon's Imagine? If they think they can be more creative than God, they should just watch the movie "Predestination" where a person is both his parents...or maybe not since it might hurt their pride in self-admiration.

The more important it is that a woman marries a Christian. One whom she could see the Lord in. If not, it is the church's duty to bring comfort to this Christian wife and bring the grace of God to her unbelieving husband, despite the hardship, surely there is hardship. No conversion is won over without battle. This is for wives, not husband, to submit, not to demean women, was the Son demeaned before the Father? Or the Holy Spirit?

Because this is the holy ordinance of God built into His code of life, one will miss what it truly means to submit to Christ, if one dismisses this passage and other relevant ones as "Paul's chauvinist" attitude or ancient history or worse: Male can be female and vice versa. There is holiness in gender: Male and Female! In fact, I would even go further and say that God created Male and Female so that we may understand what it means to submit to Christ! That we meditate on what it means to submit to Christ. We know Jesus is perfect. But husbands are not perfect, even though "husbands" should be perfect until the Fall. I would put quotations for "husbands" & "wives" before the Fall because I have no idea what human fellowship would be like before the Fall. That's another topic for another time. However, in our sinful nature, we learn submission not as perfect creatures but as sinful saints. Wives do not submit to husbands regardless of Christ, therefore there is a standard for wives in submission to their husbands IN EVERY WAY. What it is? it is a wisdom out of the Fear of the Lord.

Pak Tong said it right: That God (Yes, God) did not command wives to love husbands, because the ladies love their husbands by default. It is the husbands that have problem loving their wives. Another gender distinction. So, husbands, love your wives. This is more than protection and loyalty that American conservatives love to brag. This is a sacrificial one even when the wives are disfigured or even to a point of infidelity. Read Hosea much? This is how Christ love the Church. Not because the Church is a hot sexy super model. Beauty? God loves beauty...in fact, God created beauty! Take that, Euthyphro! God can create concepts, He is God! So why would Christ's love for a Church depend on the Church's quality? But this love is one that demands standard! SACRIFICIALLY! So the husbands must be man of God first, or how else would they get these standards?

Verse 32: This profound mystery of Christ and the Church begins from Adam and Eve before and after their fallen nature as "husband" and "wive".

So there is just so much to unpack and ponder upon. I just don't have time to do it here and now.

Posted in Reflection, Theologization | Leave a comment

Another failed attempt to justify Israel's special in this era

Listened to 3 - 02 - 18 - Janet - Mefferd - Today - Michael Onifer - Israel.

Janet asked sharp direct questions on Israel's unique stand today. She was certainly kinder (compared to some of her other guests) to Michael's consistent failure to answer to the point.

* Michael Onifer, director of the Bethlehem Project, stops by to discuss his book, "God, Israel and You: The Scandalous Story of a Faithful God."

* Published: 3/2/18 9:30:12 PM

* Episode Download Link (43 MB): http://feeds.soundcloud.com/stream/407891100-janetmefferdtoday-3-02-18-janet-mefferd-today.mp3

* Show Notes: https://soundcloud.com/janetmefferdtoday/3-02-18-janet-mefferd-today

* Episode Feed: Janet Mefferd Today - http://feeds.soundcloud.com/users/soundcloud:users:163579675/sounds.rss

Posted in News, Theologization | Leave a comment

The Slow CCCNY may yet be hopeful

Now that Rev. Lin finally asked me to send them youtube link to Dr. Tong's Roman series for their Adult Sunday School Class, instead of burning and bringing DVD copies to the church, I'm slightly impressed. I've been waiting for this for a long...far too long time. I've given hints about that but had been ignored.

Whether this is out of a desire to be better or out of negative jealousy, I'm certainly better off. God has blessed me well.

Now, let's see how Rev. Lin who seemed to want me to teach this and that, is really serious about it. Or was it just to keep me from leaving the church.

Posted in General | Leave a comment

FOGO De Chao, 2nd Trip

Great services, always.
I don't usually rate American restaurants, really don't care. But this Brazilian Restaurant on 53rd not only offers All-You-Can-Eat, great service, it also has great quality food.

It's considered one of the very expensive restaurants, ranging from $30-$60.

NYGC ate here the last Christmas party and we each received a $25 gift card that expires on 3/1, which was why I took the last minute opportunity today.

This time, "no meat" meaning no steaks, which was great, but too expensive. Their feature is the Market Table:

Fogo De Chao, $25 gift card, last day

Everything is unlimited all you can eat: features are smoked salmon, Italian style salami, pepperoni, Prosciutto, types of cheese, fruits, salad, etc.

With beans and soup on the side. They also provide unlimited cheese breads for starter, fried banana/plantain & mash.

FOGO De Chao, $25 gift card, last day

FOGO De Chao, $25 gift card, last day

Fogo $25 gift card, last day

Price is definitely steep. But with my gift card, I only paid $5.39 + $6.61 Tips for a $30 priced meal.

Posted in Culinary, General | Leave a comment

1Timothy 1:4 (Against fantasies) The stewardship from God that is by faith

1Timothy 1:4 nor to devote themselves to myths and endless genealogies, which promote speculations rather than the stewardship from God that is by faith.

When thinking movies and tv shows and cool comics...remember this verse. Devote not to myths and useless connections, rather devote to the stewardship that is from God by faith.

Posted in Faults, Memory Verses, Theologization | Leave a comment

Free Web Conference Hosting with Screen Sharing

https://zoom.us is pretty cool! Because it's free unlimited (40 minute limit per meeting if 3-50 participants).

I came across this at MeetUp and it works really well. One thing with video streaming via Cloud is you need an expensive server/media stream service. Zoom is definitely a good deal for now.

Posted in News, Technical | Leave a comment