Hi,
Can anyone please help me with generating output report from selected outlook mailbox emails in format given below, as I am not that proficient in macros:
Sender name Sender email address Received Date Received time Subject Text body
1. AA aa@yahoo.com Mon,12th Jul 2017 14:50 P.M Details kindly mail the productivity of below mentioned no' XXXXXXXXX
YYYYYYYYYY
Regards Name etc.
2.AA bb@yahoo.com Mon,12th Jul 2017 15:50 P.M Details kindly mail the productivity of below mentioned no' AAAAAAAAAAA
BBBBBBBBBBBBB
Regards Name etc.
and so on
Further i want that all numeric contact no.'s as mentioned in Text Body heading of varying length of 10,15,17,12 digits should be extracted and get pasted in next new column heading of contact no. alongside.
Incase anyone knows how to get going, pls do help me. Any other info you require, pls do let me know. Any help is highly appreciated
Rgds
Nikhil
Can anyone please help me with generating output report from selected outlook mailbox emails in format given below, as I am not that proficient in macros:
Sender name Sender email address Received Date Received time Subject Text body
1. AA aa@yahoo.com Mon,12th Jul 2017 14:50 P.M Details kindly mail the productivity of below mentioned no' XXXXXXXXX
YYYYYYYYYY
Regards Name etc.
2.AA bb@yahoo.com Mon,12th Jul 2017 15:50 P.M Details kindly mail the productivity of below mentioned no' AAAAAAAAAAA
BBBBBBBBBBBBB
Regards Name etc.
and so on
Further i want that all numeric contact no.'s as mentioned in Text Body heading of varying length of 10,15,17,12 digits should be extracted and get pasted in next new column heading of contact no. alongside.
Incase anyone knows how to get going, pls do help me. Any other info you require, pls do let me know. Any help is highly appreciated
Rgds
Nikhil