ashmita
08-12-2021, 10:14 AM
Hello Sir,
I developed a VBA that will extract all Outlook email based on the subject line as 'Submitted' and store it in Col A and B of 'Out'sheet. My req is
1)To retrieve the digit available between square bracket from col A . E.g. '10234563' from R1
2)To extract text present between "Headline" and "Description" from COl B. E.g. '121 - Person has complained about the product' from R1
3)To pull digit from text beginning with 'TID' in first encounter. E.g. '21345' from R6
Once extraction is done, the value from req-1, req-2, req-2 need to be added into Col A, col B, Col H of Sheet "Datas" (before that clear content of sheet 'Datas' as old records might exist for earlier operation)
4)Delete entire record from Sheet "Datas" for duplicate only when [value in Col A is not null and for col B is null]
E.g.The value '11111' from R7 & R8 are duplicate. Row number 7 (R7) should be removed as it contain null value for col B
I developed a VBA that will extract all Outlook email based on the subject line as 'Submitted' and store it in Col A and B of 'Out'sheet. My req is
1)To retrieve the digit available between square bracket from col A . E.g. '10234563' from R1
2)To extract text present between "Headline" and "Description" from COl B. E.g. '121 - Person has complained about the product' from R1
3)To pull digit from text beginning with 'TID' in first encounter. E.g. '21345' from R6
Once extraction is done, the value from req-1, req-2, req-2 need to be added into Col A, col B, Col H of Sheet "Datas" (before that clear content of sheet 'Datas' as old records might exist for earlier operation)
4)Delete entire record from Sheet "Datas" for duplicate only when [value in Col A is not null and for col B is null]
E.g.The value '11111' from R7 & R8 are duplicate. Row number 7 (R7) should be removed as it contain null value for col B