.
For the email portion look at this resource. It is consider in VBA as the 'bible of vba emailing'.

https://www.rondebruin.nl/win/s1/outlook/mail.htm

See what you can do with Ron's examples. Come back for assistance.