+ Reply to Thread
Results 1 to 3 of 3

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

Hybrid View

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

    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

+ 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