A quick message from a newbie:
I have been trying to send an e-mail automatically when a button is selected in a userform. The user types in the e-mail address to send the e-mail to in a cell, say A2. The subject of the e-mail is typed in another cell, say cell A3 and the main message body in cell A4.
I will also need to e-mail an excel sheet from the current workbook as an attachment. If it is not possible to send just one sheet, I can record a macro myself to copy the sheet into a new workbook and then attach that.
I could really do with some visual basic code that will automatically do all this. I would really appreciate any help you could give!
I have been trying to send an e-mail automatically when a button is selected in a userform. The user types in the e-mail address to send the e-mail to in a cell, say A2. The subject of the e-mail is typed in another cell, say cell A3 and the main message body in cell A4.
I will also need to e-mail an excel sheet from the current workbook as an attachment. If it is not possible to send just one sheet, I can record a macro myself to copy the sheet into a new workbook and then attach that.
I could really do with some visual basic code that will automatically do all this. I would really appreciate any help you could give!