I am trying to write vba code to send, on the click of a button, an
excel worksheet which has hidden columns.
I wish to sent it to an an email address which is contained in a cell
on the worksheet, and I want to be able to add text to the body of the
email, by way of a personal message.
I have used ron de buin's examples and some code from elswhere. So far
i have managed to send a copy of the worksheet, but cannot add text
before the email is sent.
Can anyone help, pleaseI am a novice and much of my code so far has
beed done on trial and error basis.