+ Reply to Thread
Results 1 to 2 of 2

Trying to Automatically export specific fields from outlook email into Excel spreadsheet

  1. #1
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Trying to Automatically export specific fields from outlook email into Excel spreadsheet

    I am trying to automate a system I have now about emails I get from a vendors about shipping orders .I am trying to do up a macro which will automatically take the specific fields and content from the message and update a spreadsheet I have ,as soon as the email comes in.
    I have attached a copy of the email and the Fields I need updated
    SENT: which goes under column 'A' of the spreadsheet (date),
    Subject: which goes under column 'D' of the spreadsheet
    MESSAGE body : (which only the numeric entries are taken ORDER# XXX-XXXXXX format) goes into Column 'B'

    Most of these orders come from vendors who use mobile devices so I cant have them send a specific form. but the format they send the email always remains the same (that's why only numeric entries are picked from the message body)
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-17-2012
    Location
    Mississauga,Ontario
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    75

    Re: Trying to Automatically export specific fields from outlook email into Excel spreadshe

    bump No Response!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1