Copy Outlook email into Excel

Hot Topic

about listview in vba excel
fm20.dll
Problems with Project Server
Programatically Changing Excel Default Delimiter in VB.NET
Using VBA to send an MSN instant message
COM+ Error ,Error Code = 0x8004270f ,Method '~' of object '~' failed"
Executing update field only on a selected Word page
Read data from excel through VB.NET
Windows media files have changes to Nero
Print folder files to a file

Microsoft ISV

pass parameter to stored procedure
BSM Scorecard Report Views
pasting in excel
printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro
Using of APC.IDE.PreventShow property
VBA Code to save Excel w Name including cell data
Program levels requirements
Word.Application
Add code in control image in time of execution
Excel macro question - ref: sheets (hopefully a simple one!)

Copy Outlook email into Excel

I receive an email every day whose contents I have to put into Excel. I'd like to write a macro in Excel that will copy the contents of the email and paste it into Excel. The contents are always structured the same - two columns and 13 rows, and the subject is always the same. I can get the Excel part, but I'm struggling with the Outlook part.

thanks!

Answer this question

Copy Outlook email into Excel

  • ALANGTX

    per the support engineer:

    Please clarify the requirements:

    1. Version of MS Excel and Outlook used (or if we use MS Office 2003 is that OK with you )
    2. If we guide you to create a Win Application using .Net C#/VB.NET 2003/2005 or VB 6.0 instead of VBA, will that work for you
    3. Is there any content other than the described 2 columns and 13 rows in the email body
    4. Please let us know about your requirement in a more detail. What you planned to achieve and what are the steps you have already taken

    -brenda (ISV Buddy Team)



  • Copy Outlook email into Excel
Answer this question