Category Archives: Technical

Technical parts

Mail Merge: Change Sender's Email Address & Include Attachment

There appears to be no such straight forward solution from Microsoft. There are third party software/plugins that do that and they are not free, not to mention some are complicated to use. The idea with Mail Merge is not just … Continue reading

Posted in Technical | Leave a comment

How to Unblock Unsafe Attachments in Microsoft Outlook

So I got this error when a developer was emailing me a js file: "Outlook blocked access to the following potentially unsafe attachments…" Solution (from: sitepoint): 1. Close Outlook 2. Run regedit.exe Navigate to: HKEY_CURRENT_USERSoftwareMicrosoftOfficeXX.XOutlookSecurity Where XX.X indicates your version … Continue reading

Posted in Technical | Leave a comment

VSTO: Doing MS Office in Visual Studio

This is fun. First it was ClickOnce, where you can have setup program that updates itself when necessary on every run. Now, VSTO beats document level macro. Sample reference: 1. To create right click menu in Word in VSTO: https://msdn.microsoft.com/en-us/library/dd554969(v=vs.140).aspx … Continue reading

Posted in Technical | Leave a comment

MS Word issues: No Margin, error 4605 for template add-in installation, error 4068

No add-in in Word 2013. Make sure to enabled macro trust in Options. To avoid error 4605 during add-in install: Options>General>Unchecked "Open e-mail attachments and other uneditable files in reading view" If Margin keeps showing zero: Options>Display>Checked "Show white space … Continue reading

Posted in Technical | Leave a comment

NetSpot - A good freeware for Wifi Analysis

https://www.netspotapp.com/

Posted in Technical | Leave a comment

Interesting Outlook tricks: Unusual Junk Mail handling

It appears that one can actually disable the junk mail completely...rather than the popularly acclaimed that you couldn't touch some built-in filtering mechanism in Outlook. This is done at registry level. There's also the case where junk manager doesn't work … Continue reading

Posted in Technical | Leave a comment

Outlook 2016/365 Search Problem: Something Went Wrong and Your Search Couldn't be Completed

This is Indexing problem. Type Indexing Options. Get Indexing running. If not, Run in services.msc>Windows Search, if can't, be sure to start with Administrator's privilege, if not, use command "runas /user:<computername>\administrator cmd" If still can't start Windows Search in services, … Continue reading

Posted in Technical | Leave a comment

Drive Mapping Persistency

Windows Drive Mapping may not stay connected the next time. One way (official way) to ensure of it, instead of using startup script, etc., is net use persistence. net use /PERSISTENT:yes then do drive mapping. Mapping persistence status can be … Continue reading

Posted in Technical | Leave a comment

Outlook Limits

Outlook 2016, Outlook 2013 and Outlook 2010: 100,000 items per folder 500 folders total Outlook 2007: 50,000 items per folder 500 folders total Source: https://support.microsoft.com/en-us/help/2768656/outlook-performance-issues-when-there-are-too-many-items-or-folders-in If exceeded, the client will perform slowly.

Posted in Technical | Leave a comment

To Consider: Outlook Rules with Wildcards

Outlook doesn't like using Wildcards so much, but there's some tips: https://www.slipstick.com/outlook/rules/create-a-rule-with-wildcards/ Outlook doesn't support wildcards in rules, so you can't use use a * or ? character for wildcards. Instead, just specify the string you want to match. For example, … Continue reading

Posted in Technical | Leave a comment