Hi all,
I'm not a developer and quite the beginner. I work for my family on a farm and we have a heap of invoices coming in each month via email and I'd love to be able to create a macro that allows all attachments that are invoices or statements to be saved to a file on my computer.
I have a macro that is currently functioning well that pulls all attachments that include the words Ïnvoice or Statement into a folder on my computer.
This is it below:

But now I have a huge file filled with a bunch of files (invoices and statements) that are badly named and I don't know what they are unless I open them up.
So, I'd love to be able to rename the attachment to include the email domain & the date received.
For example - I get an invoice from a company called Queensland Bearings - their email address is "admin@queenslandbearings.com.au" and the email was received on the 1st April 2018. I would like the attachment to be saved as "QueenslandBearings-20180401"
Can someone please help me with the code for this?
Greatly appreciated
Sarah.

It worked beautifully!!! Thank you so much and also thank you for explaining the steps!! It's greatly appreciated!!
If you have any suggestions as to what websites or course that I should look into to learn VBA that would be great. If not, thanks again for all of your assistance