+ Reply to Thread
Results 1 to 1 of 1

How to find specific header and copy the specific content in the mail body

  1. #1
    Registered User
    Join Date
    01-27-2017
    Location
    INDIA
    MS-Off Ver
    2016
    Posts
    90

    How to find specific header and copy the specific content in the mail body

    Hi Team,

    i have gone through many outlook forums and could not able to figure out correct code for my requirement.

    i have group mail box in we receive mails frequently with Subject line " Request ID 691941: Call Lodged "
    here 691941 keep changing with request coming in mail box and remaining will be same.

    what my requirement is:
    1. My Macro should keep reading the group mail box when ever it sees a new mail with only subject line contains "Request ID xxxx: Call Lodged " remaining mails can be ingnored
    2. from mail body it should copy only these fields to excel.
    i) Request ID 691941 (in this only 691941 should be copied to excel)
    ii) Severity Level: Sev2 (in this only Sev2 should be copied to excel)
    iii) Product: FINCORE (in this only FINCORE should be copied to excel)
    iv) Customer:FINATS (in this only FINATS should be copied to excel)
    v) Date & Time : when this mail was received date and time



    my excel sheet looks like the attachement in that "Daily Calls From Outlook" sheet in that the data should copy in those fields accordingly

    remaining fields are not required as of now.

    any help is appreciated
    Attached Files Attached Files
    Last edited by narsing18; 04-25-2017 at 05:12 AM.

+ 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. Replies: 2
    Last Post: 04-12-2017, 04:27 AM
  2. [SOLVED] Find specific text within workbook's name, copy and paste it to specific cell
    By axtryo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-09-2017, 02:57 AM
  3. [SOLVED] Copy and paste body of unread email from a specific folder to excel
    By Teblol in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2016, 04:04 PM
  4. Find last used cell from a col with specific header
    By EXLwiz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2015, 01:10 PM
  5. [SOLVED] VBA macro to find specific cells, copy the content and paste to ranges
    By tauterouff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-28-2014, 09:14 AM
  6. Copy specific cells as text into body of a new OUTLOOK message
    By guido0136 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-03-2014, 09:12 AM
  7. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM

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