We have a vendor who manages the web-based presentation of some required
compliance training. To improve the process, we would like to send out an
individualized URL to every employee (probably using their Employee ID in the
URL) instead of the current process, which requires each employee to click a
generic URL and log in.
Other than the obvious (a VBA loop through an array of email addresses and
Employee IDs, probably loaded from an Excel file) are there any other tips,
tricks, or gotchas associated with this type of bulk internal email
generation? All emails will only be to our internal employees, but we do have
several domains and two different exchange servers. I anticipate that we
would generate 100% of these emails from one location (one computer, which is
on Exchange Server 1), just for convenience.
Example:
Group 1/ Exchange Server 1: @companyUSA.com
: @companyCorp.com
: @companyservice.com
Group 2/ Exchange Server 2: @companyEMEA.com
I'd be more likely to do this from Outlook2007, but could use Outlook2003 if
there was a good reason to do so (if any relevant features have been
depreciated).
I'm be inclined to do this in Outlook (despite my greater familiarity with
Excel VBA) to avoid getting a warning with each email, or having to set it up
with CDO.
I appreciate any thoughts you have; I am interested in feedback on overall
approach or potential problems, I don't think the code itself will be that
much of a problem, but I want to make sure I figure out the best solution
before I start coding for it. If I have code problems I can alway post those
later.
Many thanks,
Keith
|
Similar Threads
