VBA Email Management System
- or -
Post a project like this£50(approx. $63)
- Posted:
- Proposals: 3
- Remote
- #906751
- PRE-FUNDED
- Expired
Description
Experience Level: Intermediate
General information for the business: Financial Services Company
Kind of development: New program from scratch
Description of requirements/functionality: Summary:
A Microsoft Outlook 2010 VBA macro that performs actions on the selected emails based on an external Excel spreadsheet. The spreadsheet will act as a central email hub that allows multiple actions to be controlled outside of Outlook, in one manageable place.
I would like this macro to have the following functionality, in order or priority:
1. A master Excel spreadsheet controls what action is performed on the email (i.e. save attachment, file away, and mark as read etc.) depending on whether the email is found within the master spreadsheet list of actions. This can be matched by Subject, Sender etc. and again is dictated on the spreadsheet. I envisage a loop used on the selected outlook items, checking whether the email matches in the list and if found, performs the corresponding action.
2. The option to compile a list of emails NOT found in the list would be required. If not found, they can then be added to the list with the relevant actions added as well.
Issues:
1. The macro needs to be able to handle multiple inboxes.
2. The macro needs to be able to handle dynamic subject titles i.e. matching the start or part of the subject title to the master spreadsheet.
If you can think of a more efficient way of coding this procedure to perform what is required then by all means please provide your proposal.
OS requirements: Windows
Extra notes:
Kind of development: New program from scratch
Description of requirements/functionality: Summary:
A Microsoft Outlook 2010 VBA macro that performs actions on the selected emails based on an external Excel spreadsheet. The spreadsheet will act as a central email hub that allows multiple actions to be controlled outside of Outlook, in one manageable place.
I would like this macro to have the following functionality, in order or priority:
1. A master Excel spreadsheet controls what action is performed on the email (i.e. save attachment, file away, and mark as read etc.) depending on whether the email is found within the master spreadsheet list of actions. This can be matched by Subject, Sender etc. and again is dictated on the spreadsheet. I envisage a loop used on the selected outlook items, checking whether the email matches in the list and if found, performs the corresponding action.
2. The option to compile a list of emails NOT found in the list would be required. If not found, they can then be added to the list with the relevant actions added as well.
Issues:
1. The macro needs to be able to handle multiple inboxes.
2. The macro needs to be able to handle dynamic subject titles i.e. matching the start or part of the subject title to the master spreadsheet.
If you can think of a more efficient way of coding this procedure to perform what is required then by all means please provide your proposal.
OS requirements: Windows
Extra notes:
Rob H.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
11 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies