
Loop Existing Outlook VBA Macro
- or -
Post a project like this3385
$75
- Posted:
- Proposals: 3
- Remote
- #1291357
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 2 week turnaround, complete upon successful testing of new loop
General information for the business: We handle high-volume email boxes
Kind of development: Customization of existing program
Description of every module: Existing modules: VBA macro built for Outlook 2010. At run-time, the macro asks the User to select an email folder and then to select a Windows file folder. The macro runs through the email folder + its sub-folders one at a time and "transfers" every folders' email attachments to the selected file folder, leaving a link to said file folder in the emails. Macro runs great 95% of the time.
Description of requirements/functionality: Current macro requires email to be pre-loaded (as Full Items) from their Microsoft Exchange server or the process won't run as intended. Currently User has to manually select the intended folder(s) to let their emails load then log on hours later to run the macro on the intended folders.
Your job is to add a loop feature so that the macro runs as follows:
Step 1. With existing Code, User runs macro and selects the email folder and file folder as inputs
Step 2. With new Code, For Each email folder from the selected folder and its subfolders
a. Sync to MS Exchange
b. Once folder is fully synchronized, run the macro on the folder
c. Once emails are handled loop to the Next folder
Bonus. Improve run-time by halting background Syncs to MS Exchange
a. Macro runs on a dedicated PC, e.g. Inbox/other folders don't need to be Synced locally
Turnaround time: Important but non-urgent. I'd expect this to take a matter of hours within the next 2 weeks.
Additional Notes: I'm much more familiar with VBA for Excel, and I couldn't figure out how to run the Sync and detect that it was complete. My understanding is that it's possible to add an email folder to a custom Send/Receive group, run the Send/Receive, and then remove the email folder from the Send/Receive group before repeating for the Next folder. Open to alternative solutions.
Many thanks!
Kind of development: Customization of existing program
Description of every module: Existing modules: VBA macro built for Outlook 2010. At run-time, the macro asks the User to select an email folder and then to select a Windows file folder. The macro runs through the email folder + its sub-folders one at a time and "transfers" every folders' email attachments to the selected file folder, leaving a link to said file folder in the emails. Macro runs great 95% of the time.
Description of requirements/functionality: Current macro requires email to be pre-loaded (as Full Items) from their Microsoft Exchange server or the process won't run as intended. Currently User has to manually select the intended folder(s) to let their emails load then log on hours later to run the macro on the intended folders.
Your job is to add a loop feature so that the macro runs as follows:
Step 1. With existing Code, User runs macro and selects the email folder and file folder as inputs
Step 2. With new Code, For Each email folder from the selected folder and its subfolders
a. Sync to MS Exchange
b. Once folder is fully synchronized, run the macro on the folder
c. Once emails are handled loop to the Next folder
Bonus. Improve run-time by halting background Syncs to MS Exchange
a. Macro runs on a dedicated PC, e.g. Inbox/other folders don't need to be Synced locally
Turnaround time: Important but non-urgent. I'd expect this to take a matter of hours within the next 2 weeks.
Additional Notes: I'm much more familiar with VBA for Excel, and I couldn't figure out how to run the Sync and detect that it was complete. My understanding is that it's possible to add an email folder to a custom Send/Receive group, run the Send/Receive, and then remove the email folder from the Send/Receive group before repeating for the Next folder. Open to alternative solutions.
Many thanks!
Luis B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
17 Nov 2016
United States
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