Embedded Files
Mail2Who Template Intro
Purpose of Macro: Functions like a phone-book. Just need to save / tag the number to a name once and you no longer need to remember the number. For this case, Just need to tag an event/process to the list of people required to be included.
Suitable for corporate culture where emails relating to specific topics involves a pretty long CC list of all the respective official point of contacts. (Most likely mandatory to be kept in the loop)
Function: Select the respective issue/action to trigger a lookup which will include the relevant official point of contacts into the Email / CC list accordingly based on table setup done up in Email_LIST tab.
(E.g "SAP - Create New Vendor" is selected in example on the right)
A standardised title for the respective email topics will be created to facilitate tracking later on.
Remarks: Saw this being practised by certain banks for controlling and directing their internal flow of emails. Hope this simple template is applicable for your company (and new hires) as well.
Mail2Who Template Download
Just a quick observation on some housekeeping issues: Quite a significant amount of time is spent searching ~ either for files or emails.
Both Windows Explorer (for files) and Microsoft Outlook (for emails) does have a search field to aid users in the search. However this can only be handy provided if a certain standardised naming convention has been adhered to.
Above Screenshot: Using the search function to perform keyword search in Windows Explorer / OUTLOOK in locating your stuff (On a side note, Wildcards like * and ? are applicable)
NAMING CONVENTION
For a standardized naming conventions pertaining to Spreadsheets, its been mentioned previously in a separate article on using a batch renaming macro: Batch Rename Files based on cell
For a standardized naming conventions pertaining to Emails, perhaps the Mail2Who Template as per attached could help.
Page updated
Google Sites
Report abuse