ind specific Subject line from outlook and copy the content of the email body to exce

Status
Not open for further replies.

Kittu

New Member
Outlook version
Outlook 2016 64 bit
Email Account
IMAP
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 I would like to do is;

My Macro should keep reading the group mail box when ever it sees a new mail with only subject line contains "Request ID ******: Call Lodged " remaining mails can be ignored

  1. from mail body it should copy only these fields to excel.

    i) Request ID ****** (in this only ****** ( Numeric number) should be copied to Excel)

    ii) Severity Level: Sev2 (in this only Sev2( this field keep changing like Sev1 or Sev3) should be copied to Excel)

    iii) Product: FINCORE (in this only FINCORE(This filed keep changing) should be copied to Excel)

    iv) Customer:FINATS (in this only FINATS(This field keep changing) should be copied to Excel)

    v) Date & Time : when this mail was received date and time

this should be copied in Excel in specified columns.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
J Autoreply email recieved from specific sender after deleting some text from body. Using Outlook 0
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 4
J Diane's Delay Delivery at Specific Times Questions Outlook VBA and Custom Forms 7
R How to get the Items object of the default mailbox of a specific account in a multiple account Outlook? Outlook VBA and Custom Forms 0
R Assign Categories "Round Robin" style but in a shared mailbox but on specific emails only Outlook VBA and Custom Forms 8
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1
A How to open a specific link automatically with outlook 2016 Outlook VBA and Custom Forms 6
W Remove specific contacts from contact list Outlook VBA and Custom Forms 3
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
S Outlook to check for specific text Outlook VBA and Custom Forms 3
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
Nadine Rule to move attachments with specific name Outlook VBA and Custom Forms 1
geofferyh Outlook 2010 How to Copy Outlook Attachment to a Specific Folder? Outlook VBA and Custom Forms 3
R Can not create folder to store specific emails in in Outlook for Mac Using Outlook 1
W Create Search Folder excluding Specific Email Addresses Using Outlook 5
O Rule to move (specific) messages from Sent folder to Specific folder Using Outlook 1
e_a_g_l_e_p_i Can you set reminder to specific times? Using Outlook 7
H Select Specific Account When Sending Email, Based on Current Folder Outlook VBA and Custom Forms 1
L Restrict accepted appts to specific calendar Using Outlook 2
P Import an .ics file to a specific calendar Using Outlook 4
D How to handle filing of emails from an Inbox Subfolder to a specific Public folder Using Outlook 1
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
P Auto scroll to specific folder in Folder Pane Outlook VBA and Custom Forms 3
A How to open a specific link automatically with outlook Outlook VBA and Custom Forms 13
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
K How to find specific header and copy the mail body Using Outlook 0
O How to paste website content using a specific font and removing URLs Using Outlook 2
M How to remove a list of specific contacts from Outlook Using Outlook 18
I Application_NewMailEx for a specific Email account Outlook VBA and Custom Forms 4
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
J Saving attachments from specific sender (phone number) to specific folder on hard drive Using Outlook 3
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
Diane Poremsky Delay Delivery of Messages Sent at Specific Times New Slipstick.com Articles 0
K Extract email to excel from a specific sender Outlook VBA and Custom Forms 3
A Block user to send emails to specific set of email ids Using Outlook 1
P Selecting specific calendar from Excel Outlook VBA and Custom Forms 5
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
A Creating an outlook rule to forward an email with a specific message Using Outlook 1
M Calendar Printing Assistant Hangs only on specific Template Using Outlook 2
B Check for different domains macro to be triggered by specific domains only Outlook VBA and Custom Forms 2
N BCM suddenly crashed and not able to view specific business contact. Using Outlook 1
N Auto-forwarding an Email received from a specific Email address After slight modifications Using Outlook 4
F Outlook rule, specific words, not specific words Using Outlook 1
bifjamod Saving sent email to specific folder based on category with wildcard Outlook VBA and Custom Forms 1
nathandavies How to save emails to a specific folder on a network automatically using a macro Outlook VBA and Custom Forms 14
J Is there a way to disallow sending from certain addresses to specific email addresses? Using Outlook 2
J associate task folder with a specific calendar Using Outlook 2
C Outlook Crashing on Specific BCM Lead File BCM (Business Contact Manager) 2

Similar threads

Top