+ Reply to Thread
Results 1 to 3 of 3

Copy and paste body of unread email from a specific folder to excel

  1. #1
    Forum Contributor
    Join Date
    10-10-2014
    Location
    New Jersey
    MS-Off Ver
    2010 & 2013
    Posts
    269

    Copy and paste body of unread email from a specific folder to excel

    Hi All,

    Is it possible to create a code so that every time I open my excel workbook it checks for unread messages in my "Changes" folder and
    copies the text that is in the body of the email to column A on my "Changes" sheet? I have searched around for this but have not been
    able to find anything. Most of the results that pop up are so specific to the user asking the question that it does not help me. I am using
    Excel 2010 and Outlook.
    Last edited by Teblol; 07-19-2016 at 02:40 PM.

  2. #2
    Forum Contributor
    Join Date
    10-10-2014
    Location
    New Jersey
    MS-Off Ver
    2010 & 2013
    Posts
    269

    Re: Copy and paste body of unread email from a specific folder to excel

    I should actually make my request more clear. I receive about 5 emails a day that are automatically moved to a folder called "- Changes" in outlook. I would like to create a code that searches the unread emails in this folder and have the body of the email placed into column B on a sheet called "Changes". The format of the emails is always the same. It is always a line of text, double space, another line of text. I would like each line of text to be on their own row rather than the entire body placed in one cell. Attached shows an example of what I am looking for.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-10-2014
    Location
    New Jersey
    MS-Off Ver
    2010 & 2013
    Posts
    269

    Re: Copy and paste body of unread email from a specific folder to excel

    I was able to find a code that works. Marking the thread as solved.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste Excel range as picture into Outlook email body using excel vba
    By ExcelDoc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2016, 09:29 PM
  2. Copy and paste text and a chart into Html Email body
    By rpinxt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2014, 09:22 AM
  3. Help with Copy Range from Tab and Paste In Outlook Email Message Body.
    By N4VBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2014, 03:40 PM
  4. Is there a way to Copy And Paste Excel Range As Picture Into Outlook Email Body Using Exc
    By dineshsachidananda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2014, 09:00 AM
  5. [SOLVED] Vba code copy range and paste special in email body
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2013, 12:48 PM
  6. Copy/paste select cells in active row for use in email body
    By rkovsonic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2013, 05:41 PM
  7. Copy and paste 2 excel sheets in message body of email
    By rrmando in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2006, 05:10 PM

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