Apologies if this has been asked before and it can't be done, but, I'm trying to automate the following (I'm not a great VBA user, I'm afraid)

Step One
Copy item 1 from Outlook email to MS clipboard
Copy item 2 from Outlook email to MS clipboard
Copy item 3 from Outlook email to MS clipboard
Copy item 4 from Outlook email to MS clipboard
Copy item 5 from Outlook email to MS clipboard

Step Two
Paste Item 1 into selected cell (this varies with each running of the script and will be manually selected)
Paste Item 2 into Cell one to the right of the above
Paste Item 3 into Cell one to the right of the above
Paste Item 4 into Cell one to the right of the above
Paste Item 5 into Cell one to the right of the above
Clear clipboard

If I record it as a macro the script simply pastes the text as it was initially recorded rather than the current contents of the clipboard, which changes each time.
I have to do this 500 times

To do it manually requires approximately 30 mouse and keyboard actions and takes me nearly 2 days to complete. Clearly any automation I can incorporate will help greatly.
I expect to have to carry out step one manually, but if anyone can help with part two you'll earn my eternal gratitude.

Cheers
Tom