Email attachments without user intervention

[Fyldeboy]

VBA noob (apart from editing a few existing macros) so if I'm asking too much, tell me . . .

• I have a series of xlsx files in folder 'refunds'
• Need to produce pdfs of these (single page - UK A4 size)*
• Attach all to email and send at set time (twice a week), ideally with list of attached files.
• Move all files from 'refunds' to 'complete', ideally renamed with a filename prefix/suffix 'refunded (date)'

All without any user intervention at all.

*I may be able to negotiate sending the xlxs without converting to pdf.

Using office 2016 on Windows 10