+ Reply to Thread
Results 1 to 3 of 3

Taking data from an Outlook attachment & dumping into Excel via a macro & adding to it?

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    Thurston, Oregon
    MS-Off Ver
    Excel 2010 & Excel 2013
    Posts
    46

    Cool Taking data from an Outlook attachment & dumping into Excel via a macro & adding to it?

    Okay, major newbie to Outlook macros and best a 1st grade level to writing macros in Excel. This what I would like to do:
    I receive three emails once a month with at least 13K of lines in them, I would like the first one to automatically open in Excel and paste data into a new workbook or master workbook (gonna have to use powerpivot or pivot tables once I have all data into a worksheet) then it would open the second email and paste the data into the first blank row in that new worksheet and/or master file (aka data dump), and then lastly the third email would do the same thing as the second one.

    So is this possible for someone like me who is basically cutting her teeth on how to do macros in Outlook & Excel?
    Thanks in advance for any guidance on this

  2. #2
    Registered User
    Join Date
    12-06-2012
    Location
    Thurston, Oregon
    MS-Off Ver
    Excel 2010 & Excel 2013
    Posts
    46

    Re: Taking data from an Outlook attachment & dumping into Excel via a macro & adding to it

    bump, I really need help on this..TIA!

  3. #3
    Registered User
    Join Date
    12-06-2012
    Location
    Thurston, Oregon
    MS-Off Ver
    Excel 2010 & Excel 2013
    Posts
    46

    Re: Taking data from an Outlook attachment & dumping into Excel via a macro & adding to it

    bump again

+ 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