Hi all,
I was wondering if anyone has and code which would be able to help me at all with saving emails from outlook.
What I'm trying to achieve is the following.
1. When an email is either received or sent you go to a the macros and press save
2. When you press save a text input box will appear where you can insert the customer name and project number
3. this will then search through my works server to find the folder and open the correspondence folder
4. once the folder has been open the email will be saved in that location with the date and time as a prefix to the subject.
5. once this has been done an excel workbook will be opened and information from the email will be saved in the excel document (email addresses/subject/dates/To and From/Hyperlink to email)
6.once this has been completed it will ask if you want to keep the email in your inbox or sent items Yes to keep no to delete.
I know this is a lot of information but any help would be greatly appreciated.
Bookmarks