Recent content by Dr. Demento

That worked perfectly! Thank you!!!

Michael, I appreciate the response. I'm getting conflicting messages. My first thought is that the dialog is from Outlook because Outlook VBA is writing to a closed Excel workbook and the Excel application has yet to be launched. However, the dialog box title is "Microsoft Excel" (see...

Is there a Outlook version of Excel's Application.DisplayAlerts = False? I'm repeatedly overwriting an excel file from Outlook and don't want to deal with the "Are You Really Sure You Want To Do This?" dialog box

Thanks so much, Diane! I will definitely look at those articles.

In using an awesome sub by Greg Thatcher (found here), it does a great job at extracting the information, but the output leaves much to be desired. I'm wondering if someone could help in two ways: 1) point me the the direction where I could write the output first to an array (for...

No worries; just curious if anyone else could offer some insights. You can't solve ALL the world's Outlook problems; gotta leave some for other folks! :D

Just curious if anyone had any insights as to my issues (see avatar) or my Outlook problem ;-)

Diane, No worries - I'm just grateful for the help. The missing M is a copy/paste error; it's there in 'real-life' ;-) I've altered the code a bit; I call it using If mod_Exists.ExactWordInString(objMail.Subject, "Reconciliation") = True _ Then Call Sign_Encrypt(objMail) where Set objMail...

The MSDN macro is throwing error 438 (I think I read something about ActiveInspector not working in Office 2010??). Alternatively, using the ItemSend macro is throwing error 424 - Object required Everything goes off without a hitch until "SignAndEncrypt (objMail)" Can you assist? What am I...

Awesome! Thanks much!!

Alternatively, would the code found here allow me turn on/off encryption for specified emails?

From what I've seen, past versions of Outlook did not have the capability of programatically signing/encrypting email; is this still the case for Outlook 2010 (32- or 64-bit)?? If that's still the case, would it be possible to use the code found here or here and turn it on/off programatically...