Results 1 to 2 of 2

Thread: File Selected email to folder defined by drop down list in combo box

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Apr 2022
    Posts
    2
    Location

    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
  •