VBA to send email attachment

[Charlie228]

I would like to be able to send email attachments from excel using VBA. I've got a macro that I use to generate PDFs of customer invoices from a spreadsheet and I'd like to add to the macro to open outlook, create an email, get the email address from the same spreadsheet and attach the invoice. I'm pretty sure this is possible but struggling to fine what I need. Thanks