Me being completely new to Excel VBA and need to change your instructions according to my requirements and am running into all sorts of compile errors.
Could you please help me with the VBA code for requirements as below.
I receive emails to my outlook Inbox -subfolder on daily basis, which includes hundreds of lines of data as shown in screenshot
1. Now I need to import body of the email with subject line for a specific data type U and D ( Upload and Download) for each application and it should be imported in 2 separate tables on the excel, one for U and one for D from the same email.
2. The column/row should include subject line and date
3. We need an interface on the excel macro to input the date and it should be able to extract data for those dates.
Body of the email will always remain the same format the numbers may vary, let me know if you need more information.
I would be very grateful for your help on this.
Could you please help me with the VBA code for requirements as below.
I receive emails to my outlook Inbox -subfolder on daily basis, which includes hundreds of lines of data as shown in screenshot
1. Now I need to import body of the email with subject line for a specific data type U and D ( Upload and Download) for each application and it should be imported in 2 separate tables on the excel, one for U and one for D from the same email.
2. The column/row should include subject line and date
3. We need an interface on the excel macro to input the date and it should be able to extract data for those dates.
Body of the email will always remain the same format the numbers may vary, let me know if you need more information.
I would be very grateful for your help on this.