Outlook Add-Ins
There are a lot of ways of sending documents to members on your team
both inside your company and outside. All of the MS Office Suite programs
have File > Send To > Mail Recipient. You can also send files to
the recipient with a routing list, as an attachment and other options
(shown below).
And most of techniques are accessible using VBA as well. It's just that,
your program wants to know that it's YOU sending the emails. Ever since
Melissa and I Love You and the other big Visual Basic worms Microsoft
has been a little fanatical about stopping any programmatic access to
email.
If you use a program that attempts to look up email addresses or send
email, warning messages pop up: "A program is trying to automatically
send e-mail on your behalf. Do you want to allow this?"
Then you have to wait a full five seconds until the Yes button becomes
enabled before you can click it. It's probably a good idea, and not that
big a problem if you're only sending one or two emails, but if you're
sending emails to a few dozen, a few hundred or a few thousand
recipients this just doesn't work.
For instance, one of our customers needed to have one giant sales report
in Excel chopped into separate Excel workbooks by sales rep and then
sent to each individual sales rep via email - you can read the whole
story in the Success
Story section. I Get It! Development helped the customer's
accounting department write the program in a custom training class and
it was a great success.
The problem is that after this security 'fix' was put in place, the program stalled out
before every email. The process is still MUCH less work than the former
manual process, but now it's a great deal more work than before
Microsoft's security 'fix'.
It's been several years since the 'fix' came out but many organizations
are still limping along, clicking 'Yes' every five seconds when they
want to send out email. That's one way to get around it...
There are a few other suggestions summarized on
Microsoft's web site in an article titled "Avoiding Excessive
Security Warnings when Sending Automated E-mail Messages".
The heart of one solution is to send the emails from inside Outlook. As
you know, any Office program can control any other Office program -
that's the central problem here, Outlook gets worried because some other
program is trying to send email.
So turn the situation on its head and have Outlook do the work you were
doing in Excel or Word and then send the email from Outlook. You can't
use simple VBA to do this - Outlook is still concerned that the program
is running from an email or visited website. You have to create a
trusted add-in to run your code. The add-in is written, compiled
and signed by a developer and then Outlook knows the program running the
code and allows emails to be sent without the security challenges.
I Get It! Development can create the program for you to automate your
email, just contact us for more
information.
|
|