VBA bring info from outlook to excel

  • Hi
    I need a macro to copy and paste information from the current active/open email in Microsoft Outlook to active window in Excel cell a21.
    The email is always the same format as follows, and the information I need is always the lines beginning 1. 2. 3. 4. 5.


    Dear xxx


    Ref: xxxxx


    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:


    1. xxxxxxxxxx
    2. xxxxxxxxx
    3. xxxxxxxxxxx
    4. xxxxxxxxxxx
    5. xxxxxxxxxx


    Regards

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!