Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Export data from Outlook Mail 2007 to XLS.  (Read 2449 times)

0 Members and 1 Guest are viewing this topic.

ilikeideas

    Topic Starter


    Greenhorn

    • Experience: Beginner
    • OS: Windows 7
    Export data from Outlook Mail 2007 to XLS.
    « on: December 08, 2012, 06:59:32 AM »
    I get 100's of outlook attachments in an email from my vendors. I need to save those on a folder in my desktop and then open each to check for data. Is it possible to export data from them  to an excel / CSV and make a list instead of opening each file?

    Please help!
    Excuse typos, posted using my mobile.

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: Export data from Outlook Mail 2007 to XLS.
    « Reply #1 on: December 08, 2012, 10:35:41 AM »
    More info might be helpful.  What type of file are the attachments?  Do they all have the same layout?  For example, if they are Excel files, do they all have the same columns of data, with the same column titles, on the same sheet? 

    ilikeideas

      Topic Starter


      Greenhorn

      • Experience: Beginner
      • OS: Windows 7
      Re: Export data from Outlook Mail 2007 to XLS.
      « Reply #2 on: December 08, 2012, 10:50:38 AM »

      Those are all Outlook 2007 emails that were returned for not reaching the person they were sent to.

      Required fields:

      Name
      Recipients email
      Domain name of the company extracted from recipient email and showing it as www.abc.com
      Date of delivery
      Date of failure / bounce
      Sender email
      All other relevant text

      Thanks!
      Excuse typos, posted using my mobile.

      soybean



        Genius
      • The first soybean ever to learn the computer.
      • Thanked: 469
      • Computer: Specs
      • Experience: Experienced
      • OS: Windows 10
      Re: Export data from Outlook Mail 2007 to XLS.
      « Reply #3 on: December 08, 2012, 10:54:45 AM »
      Again, what type of file are the attachments?  Your last reply said nothing about attachments.  Emails that were returned for not reaching the person they were sent to does not indicate an attachment. 

      Are you trying to capture all the invalid email addresses related to these returned emails?

      ilikeideas

        Topic Starter


        Greenhorn

        • Experience: Beginner
        • OS: Windows 7
        Re: Export data from Outlook Mail 2007 to XLS.
        « Reply #4 on: December 08, 2012, 11:15:42 AM »
        The attachements are outlook emails they cound not be deliverd or bounced.

        Sorry, if I wasn't clear. What happens is that I receive the outlook emails as an attachments for all Out of office, techincal error emails as attachment in email.

        I need to capture the details from those Outlook mail items received as attachments in a spreadsheet.

        Hope this makes it more clear.

        Thanks!
        Excuse typos, posted using my mobile.

        soybean



          Genius
        • The first soybean ever to learn the computer.
        • Thanked: 469
        • Computer: Specs
        • Experience: Experienced
        • OS: Windows 10
        Re: Export data from Outlook Mail 2007 to XLS.
        « Reply #5 on: December 08, 2012, 12:01:03 PM »
        Well, I don't know how you can do that in the streamlined manner you want to do it.  So, I hope someone may have a suggestion.  I do have Outlook 2007; I'll post here again if I discover a way to do this.

        patio

        • Moderator


        • Genius
        • Maud' Dib
        • Thanked: 1723
          • Yes
        • Experience: Beginner
        • OS: Windows 7
        Re: Export data from Outlook Mail 2007 to XLS.
        « Reply #6 on: December 08, 2012, 12:58:59 PM »
        If they set you up with a dedicated account for each account i believe you can have only selected bounced email notifications forwarded to you.
        " Anyone who goes to a psychiatrist should have his head examined. "

        ilikeideas

          Topic Starter


          Greenhorn

          • Experience: Beginner
          • OS: Windows 7
          Re: Export data from Outlook Mail 2007 to XLS.
          « Reply #7 on: December 13, 2012, 11:20:24 PM »
          I get only bouncebacks as Outlook emails as attachments via email. I need to export data from them to xls.
          Excuse typos, posted using my mobile.

          soybean



            Genius
          • The first soybean ever to learn the computer.
          • Thanked: 469
          • Computer: Specs
          • Experience: Experienced
          • OS: Windows 10
          Re: Export data from Outlook Mail 2007 to XLS.
          « Reply #8 on: December 14, 2012, 09:02:44 AM »
          I gather you're working with a large number of emails.  Right?  Otherwise, i.e. for personal emails or a small number of emails, I don't think this would be a very significant problem; you could just solve the issue for any instance where you discovered an invalid email address and the problem would be very limited in scope.  So, again, you seem to be working with a large number of emails.  In your original post, you said, "I get 100's of outlook attachments in an email from my vendors."  So, you have 100's of vendors for which you do not have a valid email address?

          patio

          • Moderator


          • Genius
          • Maud' Dib
          • Thanked: 1723
            • Yes
          • Experience: Beginner
          • OS: Windows 7
          Re: Export data from Outlook Mail 2007 to XLS.
          « Reply #9 on: December 14, 2012, 09:36:20 AM »
          I get only bouncebacks as Outlook emails as attachments via email. I need to export data from them to xls.

          I was just trying to think outside the box...
          " Anyone who goes to a psychiatrist should have his head examined. "