none
VBA code for Outlook to Excel RRS feed

  • Question

  • I know very little about VBA and need help. I need a code/Macro  that will allow me to select several email messages and run it to have it put the date and time received, Subject, and the 4th line of the body of the email into a spreadsheet named Verify in my documents folder. 

    The body of the email looks something like the below (i have bold the parts that are static. the lengths of that line can vary from email to email) and i would like for it to all go into the same spreadsheet with one email per line in Excel. 

    Customer Name: Bob
    Customer Email: noemail@pleasecall.com

    Event blah blah blah blahblahblahblahblahblah_Blah blah blah blah Successful

    Any help is greatly appreciated. 

    Tuesday, March 17, 2020 8:36 PM

All replies