-
File Selected email to folder defined by drop down list in combo box
I would like to create a macro in Outlook VBA that does the following
- Take the existing selected email in a folder in my inbox (note - selected email, not an email that is open in the current inspector)
- Save a copy of this email in .eml format to a local folder in my C drive.
- This folder path should be defined by a project reference list in a userform
- The project reference will be for example PR001/PR002/PR003
- The paths will be for example eg. C:\Users\username\Documents\Folder PR001 Internal Correspondence\
- The email will be saved with the date added to the subject in reverse date format - yyyy-mm-dd-Email-Subject
- The email will have all unsuitable characters removed from the subject prior to saving.
I have experience of creating the userform OK with the dropdowns, and I have some code to replace the unsuitable character, but I cannot find a way to invoke the saveas function and use the filepath associated with the reference defined in the userform.
I have followed the procedure in the following link which has the rough format I am looking for, including the unsuitable character replacement, however this code executes on the sending of an email, which is not what I am looking for.
Save Selected Email Message as .msg File (slipstick.com)
Would appreciate any help
Many thanks
Al
Last edited by ahume12; 04-07-2022 at 07:36 AM.
Reason: posted before was ready
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules