Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Outlook Email to Excel

tw1ggy98tw1ggy98 TexasPosts: 1Member
edited November 2013 in VBA

Okay, I can't seem to find specifically what i'm looking for so i'll try to explain it here. This is what the email looks like whenever I receive it:

Employee Creation

Login Account Name: FirstName.LastName

User: Last, First

Employee Number: XXXXXX

SalesRep ID/Tech ID: XXXXX

Login: XXXXXXXX

Employment Type: Employee

Title: CCR I - Tech Support

What i'm trying to do is get the Account Name, Number, Sales ID, and Login to copy in to a worksheet that already has column headers. I need each email to be on one row under the designated Header, i.e. Account Name. I have tried all sorts of code and I can get the spreadsheet to open and auto save but it doesn't put any of the information from the email in the spreadsheet. Can someone please show me the complete code that I should be using so that I can compare to what I have to find out where my glitch is? I'm so frustrated with this! LOL

Sign In or Register to comment.