Copying RANGE to next blank row of a different sheet each time data generated

Hello Everyone, quite new to VBA and it has taken me quite a while to get to this point.

First worksheet shows button 'Get Outlook Data' when clicked you choose an Outlook folder then the data is posted to the 'Outlook Results' sheet.

Each time the macro runs it clears the data from 'Outlook Results' this is required. The data is currently in columns A - K (this will no doubt be extended).

However, each time the [GetMailInfo] is run (on a button) I need to be able to paste the data to the next blank row on the 'Results History' sheet each time the macro runs.

I've attached a sample workbook.

I used the code found on this forum (noted below) but no matter where I placed it, it wasn't copying to the 'Results History' sheet. Would be great to run this automatically after [GetMailInfo].

My question, where and how do I get the macro below to automatically run after the 'GetMailInfo' macro is run. Help really appreciated thank you.

Please Login or Register  to view this content.

Please any help guidance whatsoever for this is greatly appreciated!!

Regards,
Cozza22

Just add the name of the sub before the sub ends

Please Login or Register  to view this content.

Amended copydata code

Please Login or Register  to view this content.

Thanks for the additional info.

Hi AB33,

Perfect all working as I wish.

Many thanks and have a good day.

Will close this off now.

Cozza22