Macro in excel to automate billing

I have a list of services rendered which need to be billed. I need a macro which makes the bill automatically en sends to a specific email