Auto emailig based on dates

Hello

I am looking to build some code to auto email members of staff based on a date in a column.

For example if the date in the column is 14 days away I would like to email a document (Word Document) to the employee.

Preferabbly the location of the document could be a cell reference. As there will be many documents to reference.

Subject would be "Training Joining Instructions"

The employees e mail address can get accessed from their PIN number in Column A. It would need to be able to loop through the column and send the email to possibly 10-20 members of staff.

Any advice on this code would be ideal, im not sure where to start with autro email vba.

Thanks

Gareth