Hi guys,

I have a sub that grabs email addresses/names from a table, inserts them into the relevant fields in the email then sends it and updates the relevant recordset.

I had a good search in the forum and couldn't find anything regarding attaching an excel file to the email (a standard template we require them to fill out).

Any help would be greatly appreciated.

Open a spreadsheet, turn on record macro, e-mail the spreadsheet to yourself from Excel's menu, turn off record macro, go to the VB editor and copy the code from there as a starting place for your subroutine. Look up Excel automation in Access. That should get you far down the road.