Sherrie
10-24-2011, 04:05 AM
Hi all!
I've never used VBA for Outlook. I have found various snippets of code on the above on this site, but I have absolutely no idea how to make it work to my specific situation. I've been cracking my head and losing sleep over this for over a week now, so thought it's time I asked for help :banghead:
Some Background Information
My colleagues send and receive a massive amount of emails a day
They file these sent and received emails together with attachments into a single project sub folder on Outlook
When they eventually get to filing the emails on the server, the sent emails together with the attachments gets saved in the project folder (outgoing sub folder) and the incoming emails and attachments get saved in the project folder (incoming sub folder)
At the moment, they manually copy each email into the respective sub folder on the server and manually rename them in accordance with our naming conventions
As you can appreciate, this is a very silly and unproductive way of doing things when I know that Outlook is capable of automating this whole process although I have no clue how. This also explains why the electronic filing is the bane of my colleagues' lives and why their emails end up clogged.
What I would like to Achieve
At the end of the day, with a click of a button, to be able to perform the following:
For each project sub folder on Outlook:
Save all incoming emails including attachments into the specified folder on the server in accordance with the naming convention (ProjectNo & " " & " " & Date in YYMMDD & " " & Email Subject
Save all outgoing emails including attachments into the specified folder on the server in accordance with the naming convention (ProjectNo & " " & " " & Date in YYMMDD & " " & Email Subject
Empty the project sub folder in Outlook
Any help or a point in the right direction will be greatly appreciated!
Thanks,
Sherrie
I've never used VBA for Outlook. I have found various snippets of code on the above on this site, but I have absolutely no idea how to make it work to my specific situation. I've been cracking my head and losing sleep over this for over a week now, so thought it's time I asked for help :banghead:
Some Background Information
My colleagues send and receive a massive amount of emails a day
They file these sent and received emails together with attachments into a single project sub folder on Outlook
When they eventually get to filing the emails on the server, the sent emails together with the attachments gets saved in the project folder (outgoing sub folder) and the incoming emails and attachments get saved in the project folder (incoming sub folder)
At the moment, they manually copy each email into the respective sub folder on the server and manually rename them in accordance with our naming conventions
As you can appreciate, this is a very silly and unproductive way of doing things when I know that Outlook is capable of automating this whole process although I have no clue how. This also explains why the electronic filing is the bane of my colleagues' lives and why their emails end up clogged.
What I would like to Achieve
At the end of the day, with a click of a button, to be able to perform the following:
For each project sub folder on Outlook:
Save all incoming emails including attachments into the specified folder on the server in accordance with the naming convention (ProjectNo & " " & " " & Date in YYMMDD & " " & Email Subject
Save all outgoing emails including attachments into the specified folder on the server in accordance with the naming convention (ProjectNo & " " & " " & Date in YYMMDD & " " & Email Subject
Empty the project sub folder in Outlook
Any help or a point in the right direction will be greatly appreciated!
Thanks,
Sherrie