Assume below is a excel worksheet with consolidated emails from MS outlook(by export data function as .CSV) ,
I need help to develop VBA code to trigger action to forward email from ms outlook Inbox folder where below Subject = C2, then should get forward to assign=D2,similarly C3 then should get forward to D3
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]Subject[/TD]
[TD]Assign[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Jose[/TD]
[TD]Sales2301[/TD]
[TD]12345@gmail.com[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Sam[/TD]
[TD]George[/TD]
[TD]Purchase2301[/TD]
[TD]12456@gmail.com[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Kumar[/TD]
[TD]Arun[/TD]
[TD]Expense[/TD]
[TD]45786@gmail.com[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 772"]
<tbody>[TR]
[TD]pls help.Thanks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need help to develop VBA code to trigger action to forward email from ms outlook Inbox folder where below Subject = C2, then should get forward to assign=D2,similarly C3 then should get forward to D3
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]Subject[/TD]
[TD]Assign[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Jose[/TD]
[TD]Sales2301[/TD]
[TD]12345@gmail.com[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Sam[/TD]
[TD]George[/TD]
[TD]Purchase2301[/TD]
[TD]12456@gmail.com[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Kumar[/TD]
[TD]Arun[/TD]
[TD]Expense[/TD]
[TD]45786@gmail.com[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 772"]
<tbody>[TR]
[TD]pls help.Thanks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]