I have an Excel97 spreadsheet with data in. I would like to be able to send this data in an email containing the comma seperated version (.csv).
I know you have to save the excel spreadsheet as .csv and then you can send the TextPad file in an email. I just dont know how to do this with one click of a button in Excel!
I would like the body of the email to contain the data, i.e. not just the attachment. It does this in TextPad when you select File/Send, but i would like to know how to automate it from Excel.
Hope this makes sense!
Also I would like it to be sent to the same person everytime, so is there a way of automatically putting the recipients name in the email.