Sample code for macro to forward current displayed item to fixed recipients (dist list)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using various versions OL 2000, 2002, and 2003 on several computers in
different locations.

Politely requesting help in the form of sample VBA code so I may
implement a macro to FORWARD the currently displayed email item to a
predefined distribution list.

Scenario: I receive several hundred emails per day - up to 700 after
a long holiday weekend! I dread returning to work on December
1st.... Anyway, I employ OL rules and ExLife to pre-process the
bulk. But even after processing I am left with a sizable number with
content too ambiguous or complex to trigger the rule/ExLife actions;
they must be read manually to determine if they are applicable and
require forwarding as described above. I end up forwarding 30-40 each
day. They are almost always sent to the same group of recipeints
(defined in a distribution list) and only occasionally must I add
comments to the forwarded item before dispatching it.

(Note : Since the recipients seldom change, their individual
addresses can be hard-coded within the macro, if that's much easier
than coding for a distribution list. But I have the impression it's
better programming practice to go with the dist list.)

Configuring a Toolbar button and/or an accelrator key combination to
fire the macro would be a great convenience, too, so I can read an
email and dispatch it to the dist list with a single click or keypress
(esp if I map the accelerator code to a programmable key on my
keyboard).

After the macro forwards the orignal email item, it is no longer
needed and may be deleted since - like Ms. Mosher (God bless you,
Sue!) - I archive my SENT items for a permanent record.

Thank you very much for any assistance. May the many minutes you save
me each day come back to you in health and happiness...

/Sam/
 
Got it - found a Feb 2001 article by Sue Mosher via courtesy of
Google's archives. (If anyone wants the code, search
microsoft.public.outlook.program_vba with Google's Group search with
the terms MACRO FORWARD "CURRENT ITEM" in the search box. Sue's
article should be near the top of the results list. The quotes in
"CURRENT ITEM" are significant and specify an exact phrase to find...
Omit the quotes and you'll end up with way too many hits...)

Now I have another problem, which *may* be related to recent upgrade
to OL2003:

When attempting to run macros (Alt-F8), I promptly get dumped into
the VBA editor with the error "Sub or Function not defined". This is
happening with previously working macros. After I hit OK to clear the
error, I can hit "F5" while still in the VBA editor to bring up the
run macros doalog, select any of my macros, and they work fine. In
other words, macros work fine from within the VBA editor but not from
the normal Outlook interface.

Can anyone help me fix this? I tried following the MS "Help" links
associated with the error window, but none of those helped....

/Sam/
 
Back
Top