My job currently requires me to send out emails via Outlook to about 50 different distribution lists every Friday. Each email has 1-2 different invoices (in Excel) attached.

I have some programming knowledge but I am by no means an expert.

Can anyone assist me in the coding in Access (or any other program) that would allow me to simply upload the invoices and automatically send each one to it's designated distribution list?

Thanks!