Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the email as an attachment. Has anyone done this or can someone give me a clue as to how to do this? Thanks in advance for any help.