BNET Insight

Business Hacks

Technology tips, tricks, and hacks to make your workday work better.

No More Forgotten Attachments in Outlook

January 8th, 2009 @ 8:00 am

8 Comments

Categories: Documents, Software, Time-Savers

Tags: Attachment, Microsoft Outlook, E-mail, Groupware, Microsoft Office, Office Suites, Software, Online Communications, Enterprise Software, Dave Johnson

attachment-detect.jpgIt’s easy to snicker at the dimwits in the office that have to send a message twice because they forgot to include the promised attachment the first time… right until the moment you’re the dimwit in question. Wouldn’t it be great if your mail client would warn you before you made a fool of yourself?

Well it can, of course. A while back, we told you about how, if you use Gmail, you can turn on the Forgotten Attachment Detector to detect e-mails that make empty promises about attachments.

This time around, I’ve got some attachment love for Outlook users. Mark Bird has written a macro for Outlook that warns you when you fail to add an attachment to an e-mail that says “attach,” “attachment,” or the like. And don’t worry: Even if you think that a macro is some sort of coconut-infused cookie, it should only take you about 20 seconds to get this up and running thanks to the simple instructions.

I do have a complaint, though: Neither of these add-ins recognize my personal shorthand for attachment — “atch” — so I’m not quite immune to missing attachment dimwittedness. But it’s a start.

Got a tech dilemma? We're here to help.
.
 
Reply to Story

BNET TalkbackShare your ideas and expertise on this topic

Subscribe to this discussion via Email or RSS

  •  
    1

    dingbat01

    01/09/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    This only really works when using test mode email. It's needs to be adjusted for HTML email, I've had this problem before.

    And to change to your shortcut ???atch??? just change the line

    intIn = InStr(1, Left(strBody, intIn), "attach")

    to

    intIn = InStr(1, Left(strBody, intIn), ???atch???)

    however this means is will ignore "attach".

    better to add a line after the original assignment such as

    intInA = InStr(1, Left(strBody, intIn), ???atch???)

    and change the line:

    If intIn > 0 And intAttachCount <= intStandardAttachCount Then

    to

    If (intIn > 0 or intInA > 0) And intAttachCount <= intStandardAttachCount Then

    not tested but gives an idea of what to do...

    regards
    Sean

  •  
    2

    dingbat01

    01/09/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    "test mode" - should read "text mode"...

  •  
    3

    BizHacks Dave

    01/10/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    Thanks! I knew it would be simple to add some sort of OR statement to the macro to address "atch," but my programming skills are negligible. I will give this a shot.

  •  
    4

    Nugby

    01/11/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    Unfortunately, from about Outlook 2000 onwards you can expect the message "A program is trying to access e-mail addresses etc" on every single email you send from that point onward (or at best you can allow it to work for ten minutes) unless you install third-party software to evade outlook's security function. Not having Admin priviledges on my work computer, this code ends up being pretty useless without including Extended MAPI functions (that I don't know how to build).

  •  
    5

    Nugby

    01/11/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    Security prevented me from installing 'Advanced Security for Outlook' (http://www.mapilab.com/outlook/security/) but i was able to download and install ClickYes (http://www.contextmagic.com/express-clickyes/) and it works with this code, so I'd recommend it to anyone else planning to use this and getting the alert.

  •  
    6

    BizHacks Dave

    01/12/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    I haven't expereinced the problem you mention, but that might be because I am an admin on my machine, even at work.

  •  
    7

    mbernier52

    05/29/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    So how do you adjust for HTML? I tried this and get a "Compile Error: Ambiguous name detected:Application_ItemSend"
    I am not a programmer, but I like to play!
    Thank you.

  •  
    8

    trngguy

    08/06/09 | Report as spam

    RE: No More Forgotten Attachments in Outlook

    I'm running Windows Vista and Office 2007 and have no problems with using this macro. I passed it along to some friends that are still running XP and they have issues with the "A program is trying to access e-mail addresses ..." warning. What do they need to do to allow this to work? Other than upgrade to Vista/2007.

Please add your comment:

  1. You are currently: a Guest |
  2.  

Basic HTML tags that work in comments are: bold (<b></b>), italic (<i></i>), underline (<u></u>), and hyperlink (<a href></a)

advertisement
Quick Poll
What is the top reason for going back to Business School?
Career Advancement
Networking
Personal Growth
All of the Above

Blogger Profiles

  • Blogger Thumbnail Dave Johnson Over the past 20 years, Dave Johnson has written three dozen books (including the best-selling How to Do Everything with Your Digital Camera), co-hosted a weekly call-in radio show, and covered technology for a long list of magazines that include PC World and Wired. As his neighbors can attest, he also plays drums. more »

advertisement
  • Click Here
  • Click Here
  • Click Here
advertisement