Hi Cait783,

From my reading of the code, it saves the workbook, then sends it as an attachment. In that case, the attachment should always be the most recent file in the folder. In other words, it already does what you say you want it to.

PS: When posting code, please post formatted code, using the code tags. They're on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]