I am trying to write vba code to send, on the click of a button, a range of
cells which exclude certain hidden colums.
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 bruin's examples and some code from elswhere.
So fari have managed to send the modified range, but it does not give me
the opportinuty to add text or to retrieve it from elsewhere before the
email is sent.
Can anyone help, please?
I am a novice and much of my code so far has
beed done on trial and error basis.
Peter Vaughton