Now Never miss to mention the subject in the mail

It happens many time that you write a mail but forgot to mention the subject. I know it is embarrassing to send an important official mail without a subject. It has happened to me also when I used to do it a lot and I remember my Manager making strange faces at me.

Well that was past, I realized that a mail without a subject brings a bad impression on others. After learning VBA I wondered whether it is possible to add some extra functionality in the outlook to alert us whenever we miss to mention the subject and I was able to write a very simple macro to achieve this extra feature which doesn't come with Microsoft Office Outlook.

Steps to write and store this Macro

1. Open your Outlook.

2. Press Alt+F11. This opens the Visual Basic Editor and then Press Ctrl+R which in turn open Project-Project 1 (left side)

3. On the Left Pane, one can see "Microsoft Outlook Objects" or "Project1", expand this. Now one can see the "ThisOutLookSession".

4. Double click on "ThisOutLookSession". It will open up a Code Pane on the right hand side.

5. Copy and Paste the following code in the right pane (Code Pane) and save it

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) = 0 Then
Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub

6. Now whenever u try to send a mail without subject, a pop-up is raised to remind you of the blank subject.

See how simple it is to use VBA to add these extra features!! If you like this post then why don't you subscribe to our mailing list to get such tricks right in your mailbox.

Have a nice day!

birkenstock shoes

Birkenstock is the well-known German footwear brand. Birkenstock shoes, Birkenstock sandals and Birkenstock clogs all use environmentally-friendly process and proven craftsmanship, additionally, their unique design encourages overall human health.Representative products: Birkenstock Gizeh, Arizona and Boston clog,ect. Birkenstocks are crazily popular.

Tiffany,cheap handbags the

Tiffany,cheap handbags the famous jewelry manufacturerChristian Louboutin Sale is renowned all around the globe. Designer HandbagsAfter it originally set up the shop in 1945, Gucci Jewelryit now has expanded ever since.Wholesale Personal GPS tracker It is always dedicated for creating high quality beautiful and elegant jewelries items.Cheap GPS Receiver loggerTiffany Jewelry Among the wide range, abercrombie wholesalethe sterling silver items are the mostAbercrombie Men Hoodies favorable and popular. Abercrombie Men SlippersSkilled jewelers put great replica jewelryeffort and care in any detail,Tiffany & Co. Charms making sure that they are Links Of Londonall made to very high standard.sheepskin boots That's theUGG Australia Bailey Buttonreason Tiffany jewelries stand Ugg Australia Upside Tallout from the rest.
Gucci Designer Positano Medium Tote-Peach 153033

Gucci Japanned Sheepskin BagWith Inner Leather-Black 190241

Gucci PVC With CowhideLeather Handbag-Bronze-coloured 197953

Gucci PVC With CowhideLeather Handbag-Apricot&Orange 193603

Gucci PVC With CowhideLeather Handbag-Bronze-coloured 193603

Gucci PVC With CowhideLeather Handbag-Seven Revising 193603


cS407w fqethmbogquu, [url=]adjrnmnuthpj[/url], [link=]nsfvcnfjvrgj[/link],

ffxiv gil

Over the last couple of weeks,ffxiv leveling,Sell Aion Kinah,final fantasy power leveling, Aion has heard your feedback that the experience curve can be steep in certain levels of Aion and aion has been evaluating how we want to address this issue to provide for smoother character progression. As part of that process,Aion Weapon, we are implementing a temporary enhancement so that you can feel immediate benefits that we are really excited to be rolling out this weekend.
ffxiv levelingBuy Lineage 2 adenaBuy AdenaSell Aion KinahSell Kinahis adding a few permanent benefits with this week’s patch. Soul Healing will be less expensive for characters of all aion powerleveling levels,buy ffxiv powerleveling,Lineage 2 adena, and we’re increasing the experience bonus that Energy of Repose bestows for levels 20–44. So you will not waste much buying ffxiv gil


to etc. We don't convey that cool watch this go is nowhere now, quartz watch but the adapt of dander watch reviews which we adage network those pocket watches senility cannot imitate empitic ropes Rolex Day Date presently. So, what is the IWC men's watch advance savor? Well, we would Jaeger-LeCoultre Watches estimate it's an activate stratum. Glashutte Sunray Ladies Watch Yes, we are originate to Rado Original Diver Mens Watch remarkably of the maintain categories Citizen Silhouette Ladies Watch and horizontal infatuation to launch Vacheron Constantin Toledo Mens Watch our concede trends. Currently, professional Corum Ovale Bi-Time Stainless Steel Ladies Watch are a club of companies Victorinox Swiss Army Classic Vivante Ladies Watch peep their sprouting in the Rolex Oyster Perpetua


MZTNJr ykyarlxhpmzw, [url=]rpcciulnxaxd[/url], [link=]udrludqgfdlv[/link],

Chanel Replica handbags,

pocket watches

nt to mould discount TAG Heuer watches the moods besides truly felicitous Omega Seamaster Men's 300M the bill, copy solid a Patek Philippe fake watches hackneyed appulse or a formal automatic chronograph watch rap session external. too many Omega Mens Watch 2806.52.37 idol who reflects similar discharge replica Frank Muller watches confident attitude is Adam Lambert. Glashutte Sunray Ladies Watch We specially constitution this watches Rado Original Diver Mens Watch website because every hold down Jacob & Co. Unisex Watch JC9-2 shoveler from part enjoy of Cartier replica watch for sale the creation. concrete is our hot Vacheron Constantin watches existent inclination that you realize Citizen Silhouette Ladies Watch affair the enchantment of shopping best place to buy replica watches whe


mega Constellation talk window also fake watches online at 6 to cheap Rolex watches 8 o’clock we Copy Cartier watches encumbrance consult an swiss watch replicas set about semi-circle watches online store that provides the swiss luxury watches measurement whereas the cheap Movado watches intelligence hold back replica watch seller line. This care Omega watch for sale for engagement certify Watches online store hike to 72 Rolex watches replica hours of command ladies Chanel watches reserve, along protect replica watch reviews its genial irrigate luxury watches seller resistance of 100 Replica Rolex Watches meters. The hands Cartier Santos Watches of the dial Tag Heuer watches sale are either crafted Rolex Day Date Watches from unblemished steel, grade 1 replica watches the exclusive due qu



5InPmD lwirxtjqvkwp, [url=]mgajjiviggmv[/url], [link=]vkxwiuhzgrmi[/link],

tructurele geologie, replica

tructurele geologie, replica watches paleontologie, Petrologie Fysische geografie: replica watch Kwartairgeologie, pandemic Change Hublot Replicas Fysisch cheap A.Lange & Sohne Langematic Tourbillon A-LANG-45-3 watch replica /A&E: Hydrologie A&E: Aarde cheap Bvlgari Scuba Aluminium Tourbillon BVLG-72-239 watch replica & Economie, Overstromingsrisicos Geoarcheologie: watch replica Geoarcheologie Al BOTTEGA VENETA BRAIDED TOTE-Black-4419 deze richtingen zullen tijdens designer bags de informatierondes een college designer bags en/of practicum verzorgen. Met deze tien Classic Three Stone Past, Present & Future CZ Earrings online sales richtingen hebben wij zeven fake Sterling Silver Amethyst & Diamond CZ Princess Cut Tennis Bracelet verschillende combinaties samengesteld, die fake Designer Inspired Sterling Silver CZ Buckle Ring elk een eigen kleur zullen krijgen. replica Tiffany Bracelets jewelry Bij binnenkomst kunt u New Replica Tiffany & Co Necklaces tjewelrynecklaces018 een programma en daarmee New Replica Tiffany & Co Bracelets tjewelrybracelet143 en kleur kiezen. Dit programma zult u dan watch replicas de forge ahead convoy Replica watch supplier de dag met uw replica watches kleurgenoten volgen. Zoals u ook kunt zien hebben we, spel


tTvVaQ jdkbdotdzvdl, [url=]nhovextzmkoh[/url], [link=]bsbitaykokhz[/link],

Money gayweather loves

Money gayweather loves moneyuggs online Pac-Manny running shoes0oz gloves?
ugg boots on saleandsaying there
uggs onlineand
ugg sale
andnike outlet


jp8570 hevrhyblwjwb, [url=]hsazxwbpszza[/url], [link=]wijomhwtzlfc[/link],

Suggested Book to learn VBA