Emailing range for Excel and adding body text

P

Peter Vaughton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top